Home Forums SQL Server 2008 SQL Server 2008 - General Finding min using over(order by) in sql server RE: Finding min using over(order by) in sql server

  • February 20, 2013 at 10:20 am

    #1589648

    sunder.mekala (2/20/2013)

    Hi All,

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

    i am using sql server.

    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.

    I think you need PARTITION BY rather than ORDER BY when using an aggregate with the OVER() clause.