Top 2 Clients for each Group

[#1]

Hello friends,

I have following table

Group	Client	Sales
A	Ca1	500
A	Ca2	400
A	Ca3	600
A	Ca4	200
B	Cb1	300
B	Cb2	250
B	Cb3	350

Now my requirement is to find top 2 client for each group by sales,the output table must be like

Group	Client	Sales
A	Ca3	600
A	Ca1	500
B	Cb3	350
B	Cb1	300

Thanks in advance for everyone's idea and reply..

[cesaraccardi · Accepted solution]

Hi bhawna gupta,

Have a look at the attachment, I think it's what you are looking for.

Kind Regards,

Cesar