p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Basics (http://p2p.wrox.com/forumdisplay.php?f=61)
-   -   Retrieve SOME records (http://p2p.wrox.com/showthread.php?t=24756)

jaywhy13 January 30th, 2005 02:28 AM

Retrieve SOME records
Is there a way (using SQL) that you could retrieve say the first five records?

I'm gonna download the internet if its the last thing I do....
Until the algorithm is finished u must prepared to bow down and worship me (or my grave).... i figured i'll b finished b4 the latter!

madhukp January 31st, 2005 12:50 AM

Use the query.

SELECT TOP 5 <field list> FROM <table clause> WHERE <condition clause>

All times are GMT -4. The time now is 03:42 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.