Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Keith Henry Filtering on data using the MAX function RE: Filtering on data using the MAX function
Ramesh Saive
SSC-Insane
Points: 24275
More actions
October 23, 2007 at 7:46 am
#744533
Use HAVING Clause....
SELECT GroupColumn, MAX( AnyColumn )
FROM AnyTable
GROUP BY GroupColumn
HAVING MAX( AnyColumn ) > 10
--Ramesh