devxlogo

Limiting SELECT Results to Only a Few Rows

Limiting SELECT Results to Only a Few Rows

Question:
How do I limit an SQL SELECT statement to returning just the top ten producing offices?

Answer:
Use the TOP operator or SET ROWCOUNT to 10.

devx-admin

Share the Post: