Posted by GTi on 11/01/05 10:59

I have a large table and I want to get a spesific record.
The table is sorted by timestamp and I have a startdato column.

Now I want to get only one record less or equal to a dato:

idd startdate
....
122221 2005/01/01 02:35
122222 2005/01/01 05:01
122223 2005/01/01 10:19
122224 2005/01/01 14:10
122225 2005/01/01 18:49
....

Now I want the closest idd (less or equal to 2005/01/01 14:00 Using:
(the answer is 122222 at 2005/01/01 05:01)
SELECT idd FROM datetable WHERE startdate <= '2005/01/01 14:00:00'
gives me all the record from the beginning of the table. But I only
need the records nearest (less or equal).

Any idea?

• Next in forum: Re: SQL query question
• Prev in forum: Re: Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
• Thread view: SQL query question

[Reply to this message]