Tags: category, database, field, group, groupexin, item, master, max, microsoft, mysql, oracle, rate, ratei, select, server, sql, value

Select max value of each group

On Database » Microsoft SQL Server

215 words with 1 Comments; publish: Fri, 04 Jan 2008 10:54:00 GMT; (25076.17, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • select category, max(rate)

      from table_name

      group by category

      #1; Fri, 04 Jan 2008 10:55:00 GMT