Ask the Expert

Retrieving the first two rows in a table

How do I retrieve the first two rows in a table?

    Requires Free Membership to View

In SQL Server 2000 or later you use the TOP statement. For example:

SELECT TOP 2 * FROM authors ORDER BY au_lname,au_fname

View questions and answers from all of our SQL Server experts here.

This was first published in March 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: