SQLServerCentral / Discuss Content Posted by Keith Henry / Article Discussions / Article Discussions by Author / Filtering on data using the MAX function / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:08:52 GMT20RE: Filtering on data using the MAX functionhttp://www.sqlservercentral.com/Forums/Topic413881-153-1.aspxI'm not sure whether this will help you or not. But still I'just came across the following and thought of distributing to you.ExamplesThis example returns the book with the highest (maximum) year-to-date sales.USE pubsGOSELECT MAX(ytd_sales)FROM titlesENZOI!!!!!!!!!!!!!!!Tue, 23 Oct 2007 07:55:51 GMTVSVaidyaRE: Filtering on data using the MAX functionhttp://www.sqlservercentral.com/Forums/Topic413881-153-1.aspxUse HAVING Clause....SELECT GroupColumn, MAX( AnyColumn )FROM AnyTableGROUP BY GroupColumnHAVING MAX( AnyColumn ) > 10Tue, 23 Oct 2007 07:46:23 GMTRamesh SaiveFiltering on data using the MAX functionhttp://www.sqlservercentral.com/Forums/Topic413881-153-1.aspxFiltering on data using the MAX function. How do I formulate this statement. I'm not selecting the field;just need to filter on it.Tue, 23 Oct 2007 07:08:23 GMTShirley Thomas