|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
July 24th, 2003, 12:51 PM
|
|||
|
|||
|
Setting a limit on rows returned
Is there a way to set a limit on the number of rows returned by my query?
__________________
Do not reinvent the wheel, unless your new wheel works that much better.
|
|
#2
July 24th, 2003, 01:48 PM
|
||||
|
||||
|
Check this link . This was actually posted just a day or two ago and is on the main page of this forum. In the future you may want to browse the forum topics and/or do a search before posting.
*Note I'm aware of the fact that it's hard to distinguish tone and intent from written messages on the internet so as a pre-emptive strike I'd like to say I'm not flaming you or chastising, just trying to help... -b
__________________
PostgreSQL, it's what's for dinner...
|
|
#3
July 24th, 2003, 08:22 PM
|
||||
|
||||
|
If you're using MS SQL Server, use:
SELECT TOP n FROM .... where "n" is the number of rows you want returned. -Dave
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Setting a limit on rows returned |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
