Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi bhawna gupta,
Have a look at the attachment, I think it's what you are looking for.
Kind Regards,
Cesar
Hi bhawna gupta,
Have a look at the attachment, I think it's what you are looking for.
Kind Regards,
Cesar