SQL Query to select top 10 records except for the top 10 records

June 3rd, 2006

I just need a MySQL Query that can select the next 10 records after the first top 10 records.
- Anuj Madan

ln MySQL, you will do it this way:

SELECT *
FROM tablename
LIMIT x,y;

LIMIT x,y means skip the first x records, and then return the next y records.

So your query will look like:

SELECT *
FROM tablename
LIMIT 10,10;

Filed in Ask Jayant, Databases, MySQL, Snippets

2 Responses to “SQL Query to select top 10 records except for the top 10 records”

  1. tahir Says:
    May 10th, 2007 at 10:55 pm

    data
    idno Email Category
    1 a@a.com c
    2 b@b.com c
    3 b@b.com c
    4 b@b.com c

    only unique email address record are requierd.
    1 a@a.com c
    2 b@b.com c

  2. Jayant Gandhi Says:
    May 14th, 2007 at 4:04 am

    @tahir:
    SELECT idno, UNIQUE(Email), Category
    FROM tablename;

Leave a Reply