Finding min using over(order by) in sql server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Finding min using over(order by) in sql...

Finding min using over(order by) in sql server

Rate Topic

Display Mode

Topic Options

Author

Message

sunder.mekala

Posted Wednesday, February 20, 2013 8:12 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 10:39 AM
Points: 16, Visits: 26

Hi All,

I am trying to write a sql to find the minimum of a dataset

select ST.BG_DTTM
,MIN(ST.BG_DTTM) over(ORDER BY ST.BG_DTTM) AS "Minim"
from
tablename ST

but it is giving me a error saying

Error: Incorrect syntax near 'order'. (State:37000, Native Code: 66)

any help is appreciated.

Thanks,
Sam.

Post #1422107

Andy Hyslop

Posted Wednesday, February 20, 2013 9:08 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:34 AM
Points: 595, Visits: 2,128

Cross Post

http://www.sqlservercentral.com/Forums/Topic1422113-391-1.aspx

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Post #1422142

« Prev Topic | Next Topic »

Permissions