Pages

Search This Blog

Friday, 22 July 2011

SELECT TOP 5 RECORDS

Syntax:
SELECT [column names] FROM [table name] LIMIT [no of records]


Example:
SELECT * FROM Persons LIMIT 5
Posted by at

2 comments:

  1. Sasi23 July 2011 at 07:46

    To select from 10th record to 20th record of a result set??

    SELECT * FROM Persons LIMIT 10,10

    ReplyDelete
  2. zahir22 August 2011 at 16:49

    To select the customer getting 10th largest salary in customer table ?

    ReplyDelete

Subscribe to: Post Comments (Atom)