[thelist] ASP: Select only the first record

Casey Crookston casey at thecrookstons.com
Thu Jun 19 11:05:39 CDT 2003


How would one select only the very first record from a table.  This select
statement, of course, adds all rows to a recordset.  What I want is only the
record with the most recent date...

"SELECT * FROM news ORDER BY date DESC"

Thanks,

Casey



More information about the thelist mailing list