SELECT TOP 5 * FROM someTable Where blah blah blah ORDER BY SomeIncreasingValue DESC
That works in SQL SERVER This works in ANSI Compliant SQL like postgreSQL SELECT * FROM someTable Where Blah blah blah ORDER BY SomeIncreasingValue DESC LIMIT 5 At 10:00 PM 7/29/02, you wrote: >Brain shorting out....what is the quick way in SQL to grab the top 5 >rows, ie rows with the highest integer value in a database. *fry* >.must ... Find... Sleep! > >Thanks a million. > >Regards, > >Eric J Hoffman >DataStream Connexion >www.datastreamconnexion.com >Delivering Creative Data Solutions > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
