How can I select rows by range

Question

Possible Duplicate    Select statement in SQLite recognizing row number       For example  SELECT   FROM table WHERE  row  BETWEEN x AND y  How can this be done  I ve done some reading but haven t found anything specifically correct   Imagine a list where you want results paged by an X amount of results  so for page 10 you would need results from rows 10   X to 10   X   X  Rather than display ALL results in one go

User · Accepted Answer

For mysql you have limit  you can fire query as    SELECT   FROM table limit 100  -- get 1st 100 records SELECT   FROM table limit 100  200  -- get 200 records beginning with row 101   For Oracle you can use rownum  See mysql select syntax and usage for limit here   For SQLite  you have limit  offset  I haven t used SQLite but I checked it on SQLite Documentation  Check example for SQLite here

User · Answer

Following your clarification you re looking for limit   SELECT   FROM  table  LIMIT 0  10    This will display the first 10 results from the database   SELECT   FROM  table  LIMIT 5  5     Will display 5-9  5 6 7 8 9   The syntax follows the pattern   SELECT   FROM  table  LIMIT  row to start at    how many to include        The SQL for selecting rows where a column is between two values is   SELECT column name s  FROM table name WHERE column name BETWEEN value1 AND value2   See  http   www w3schools com sql sql between asp  If you want to go on the row number you can use rownum   SELECT column name s  FROM table name WHERE rownum  BETWEEN x AND y   However we need to know which database engine you are using as rownum is different for most

User · Answer

You can use rownum    SELECT   FROM table WHERE rownum  gt  10 and rownum  lt   20

User · Answer

Have you tried your own code  This should work   SELECT   FROM people WHERE age BETWEEN x AND y

User · Answer

Using Between condition  SELECT   FROM TEST WHERE COLUMN NAME BETWEEN x AND y     Or using Just operators   SELECT   FROM TEST WHERE COLUMN NAME  gt   x AND COLUMN NAME    lt   y

User · Answer

Use the LIMIT clause      rows x- y numbers    SELECT   FROM tbl LIMIT x y    refer   http   dev mysql com doc refman 5 0 en select html

User · Answer

Assuming id is the primary key of table    SELECT   FROM table WHERE id BETWEEN 10 AND 50   For first 20 results   SELECT   FROM table order by id limit 20

[sql] How can I select rows by range?

Examples related to sql

Examples related to sqlite