tough sql question..

[eja2000]

i have news articles in a table;
articlename
articlebody
articledate
articleid(integer autonumber)


i want to create an sql statement that will retrieve all records BUT the most recently added one.
the most recent article is the one with the highest articleid..
thanks

 

[PHV]

Something like this ?
SELECT * FROM tblArticles
WHERE articleid<(SELECT Max(articleid) FROM tblArticles)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[eja2000]

thanks!!