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

  • 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