sunder.mekala (2/20/2013)

---

if i go woth your suggestion then i need to group it by the other non aggregated columns, if i group it my results will go wrong, so i am thinking to use min(column1) over (order by column1) .

Any suggestion is appreciated.

Thanks,
Sam.

if i go woth your suggestion then i need to group it by the other non aggregated columns, if i group it my results will go wrong, so i am thinking to use min(column1) over (order by column1) .

Looks like you need to put your minimum part as a sub query if other columns are involved that you can't group by.

SELECT 
<SomeCols>

FROM
Sometable AS ST

INNER JOIN -- If no NULLs are needed from this sub query
(
SELECT
<SomeID>
,MIN(ST.BG_DTTM) 'Minim'
FROM
tablename ST
GROUP BY
,<SomeID>

) AS SubQ

ON ST.<SomeID> = SubQ.<SomeID>

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.