Filtering on data using the MAX function

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

Use HAVING Clause....

SELECT GroupColumn, MAX( AnyColumn )

FROM AnyTable

GROUP BY GroupColumn

HAVING MAX( AnyColumn ) > 10

--Ramesh

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 2

I'm not sure whether this will help you or not. But still I'just came across the following and thought of distributing to you.

Examples

This example returns the book with the highest (maximum) year-to-date sales.

USE pubs

GO

SELECT MAX(ytd_sales)

FROM titles

ENZOI!!!!!!!!!!!!!!!