Posted by David Portas on 11/01/05 11:18

> The table is sorted by timestamp
That's not correct. Tables are always unsorted.

Try:

SELECT idd
FROM datetable
WHERE startdate =
(SELECT MAX(startdate)
FROM datetable
WHERE startdate <= '2005-01-01T02:35:00') ;

--
David Portas
SQL Server MVP
--

• Next in forum: host_name
• Prev in forum: SQL query question
• Thread view: Re: SQL query question

[Reply to this message]