SELECT TOP 5 * FROM... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

SELECT TOP 5 * FROM...

Author

Topic

MorningZ
Starting Member

44 Posts

Posted - 2001-02-07 : 15:13:37

Hi everyone

I was wondering why running ( against and Access2k DB )

SELECT TOP 5 * FROM Members
works

but
SELECT TOP 5 * FROM Members ORDER BY SignupDate DESC
doesn't ?

is there an alternative way to grab the top 5 newest ones??

Thanks in advance
-Steve

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources