[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
| (Not that the people on this list aren't great too. . . ;-))

thanks for that suggestion
*the one*

More information about the thelist mailing list