SQL TOP

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL TOP - Introduction and syntax 

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL TOP statement. Write SQL syntax for the SQL TOP statement along with an example.

TOP clause is used to specify the number of records to return. Usually used for large tables.

Syntax:
SELECT TOP number|percent column_name(s) FROM table_name

Example:
SELECT TOP 2 * from employee

<<Previous  Next>>