Seemingly simple SQL query

SELECT
[Timestamp]
FROM
(
SELECT ROW_NUMBER() OVER (PARTITION BY DATEDIFF(dd,0,[Timestamp]) ORDER BY [Timestamp] DESC) AS Seq,*
FROM Table
)t
WHERE Seq = 1 

Another way is this

SELECT *
FROM Table t
WHERE NOT EXISTS 
(
SELECT 1
FROM Table
WHERE DATEDIFF(dd,0,[Timestamp]) >= DATEDIFF(dd,0,t.[Timestamp])
AND [Timestamp] > t.[Timestamp]
)

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page