A simple query :( [modified]

[xoxoxoxoxoxox]

I want to select categories with biggest id from the table below. For example, Diet should return 228 and excercise should return 225... I want distinct category with biggest id. id Category 9 Diet 218 Diet 228 Diet 8 Exercise 215 Exercise 225 Exercise 1 Investing 224 Investing 234 Investing 5 Movie 219 Movie 229 Movie Anybody can help me?? thanks in advance -- modified at 22:36 Thursday 13th July, 2006

[Andrew Bleakley]

SELECT Category, MAX(id) AS MaximumID FROM dbo.TableName GROUP BY category should do the trick. that is of course assuming you are using SQL Server, best in future to specify the actual database (and version) it removes any doubt and ensures the answer you get is accurate

[xoxoxoxoxoxox]

thank you very much. This is exactly what i wanted. :)

[Andrew Bleakley]

No worries, MAX is one of SQL Server's "aggregation" functions. There are lots - SUM, MIN, AVG etc etc and Grouping is a very powerful feature - definitly worth the time to look into and understand.