SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) / Finding min using over(order by) in sql server / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:51:49 GMT20RE: Finding min using over(order by) in sql serverhttp://www.sqlservercentral.com/Forums/Topic1422107-392-1.aspxCross Post[url]http://www.sqlservercentral.com/Forums/Topic1422113-391-1.aspx[/url]Wed, 20 Feb 2013 09:08:42 GMTAndy HyslopFinding min using over(order by) in sql serverhttp://www.sqlservercentral.com/Forums/Topic1422107-392-1.aspxHi All,I am trying to write a sql to find the minimum of a datasetselect ST.BG_DTTM,MIN(ST.BG_DTTM) over(ORDER BY ST.BG_DTTM) AS "Minim"fromtablename STbut it is giving me a error saying Error: Incorrect syntax near 'order'. (State:37000, Native Code: 66)any help is appreciated.Thanks,Sam.Wed, 20 Feb 2013 08:12:35 GMTsunder.mekala