[thelist] ASP & SQL SELECT Query - comparing dates
Elfur Logadottir
elfur at members.evolt.org
Tue Apr 10 10:29:16 CDT 2001
From: "Don Makoviney" <DonM at allensysgroup.com>
| Even better than Bob's answer would be:
|
| select * from table
| where date is (select max(date) from table)
| order by time desc
Thank you Don, this did the trick.
| Also, you might want to try ASPLISTS.com in the future as well
<snip>
| (Not that the people on this list aren't great too. . . ;-))
thanks for that suggestion
elfur
*the one*
More information about the thelist
mailing list