Select max value of each group

[hariharanmca]

Hi,

anyone know How to Select max value of each group

Ex:

in a Item master i have field category and rate

I want max rate of each Category

[navamnk]

select category, max(rate)
from table_name
group by category