Limited the number of rows being displayed

[pita2]

What is the SQL command to limite the number of rows being displayed?

Select * from cust where name=smith;

The above sql statemenat generates 500 records. But I only want the first 20. Any idea how I can narrow the results without adding extra criteria? Any help would be appreciated. Thanks.

 

[GingerR]

use TOP

SELECT TOP 20 Cust.* FROM Cust;

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[pita2]

Thanks, GingerR.