Amit Kumar

Amit Kumar

  • NA
  • 140
  • 40.9k

Sql Query using group clause

Mar 5 2014 4:01 AM
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 
 

Answers (1)