return only 20 from select query

[djam]

Hello,

How would I return only 20 results from a select query which might return more then this?

" ahhh computers, how they made our lives much simpler "

 

[Snowcrash]

SELECT TOP 20 *
FROM Table_A

should work fine.

Snowcrash

 

[SQLSister]

If you are going to return only 20 records make sure you have an order by cluase or you will not get the 20 records you want as the database order is not always the same.

Questions about posting. See faq183-874