Posted on: 3/5/2014 8:52:40 AM | Views : 568

this is my table snapshot of sql server.

i want to write a sql query , which will return only 3 row, whcih contain max offer from 3 diffrent category. like in my result there should be 3 different category id, and correspondence to that category's Offer that offer should be maximum in that category
this is my desired output

you can see there is 3 diffrent category , and offer belongs to that category is maximum from that category

Go to the complete details ...