[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