How to get number of records in SQL

Question

I am having 25 Lacs records in table , how can i get first 10 lacs after 10 lacs and after that 5 lacs records in sql Server 2008.

Could you please help me in this?

In PL SQL i do like this

SELECT * FROM temp WHERE rownum > or rownum < 10

Please suggest.

possible duplicate of [LIMIT / OFFSET in Oracle 11G](http://stackoverflow.com/questions/7326885/limit-offset-in-oracle-11g) — Lukas Eder, Mar 02 '12 at 13:38
You're looking for a way to handle `LIMIT / OFFSET` (or similar clauses from other databases) in Oracle. See this question for details: http://stackoverflow.com/questions/7326885/limit-offset-in-oracle-11g, or this one: http://stackoverflow.com/questions/7480243/sql-oracle-order-by-and-limit — Lukas Eder, Mar 02 '12 at 13:38
@Kayser: The keywords `PL / SQL` and `ROWNUM` can only be Oracle — Lukas Eder, Mar 02 '12 at 13:40

score 4 · Answer 1 · answered Mar 02 '12 at 13:42

4

SELECT * FROM 
(
SELECT ROW_NUMBER() OVER (ORDER BY [dataKeyColumnName]) AS RowNo, * FROM Temp 
) AS A
WHERE A.RowNo BETWEEN 10 AND 15

answered Mar 02 '12 at 13:42

Kaf

score 1 · Answer 2 · edited May 23 '17 at 12:12

1

It depends on the DB that you use.

For Oracle you can use

SELECT * FROM(
   SELECT ROW_NUMBER() OVER (ORDER BY [tableId]) AS RowNr, * FROM MyTable 
) AS T
WHERE T.RowNr BETWEEN 6 AND 15

For MYSQL you can use

SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15

edited May 23 '17 at 12:12

Community

answered Mar 02 '12 at 13:40

Kayser

The keywords PL / SQL and ROWNUM can only be Oracle – Lukas Eder Mar 02 '12 at 13:40

2 Answers2