If a dataset contains 100 rows, how to fetch rows between 5 and 15 only in SQL?

2 ⤊

If a dataset contains 100 rows, how to fetch rows between 5 and 15 only in SQL?

Give the exact SQL query for this

2007-02-27 18:11:29 · 5 answers · asked by aruntech 1 in Computers & Internet ➔ Programming & Design

5 answers

Hi

If u r using SQL Server 2000, then u can use the below query:

select top 10 * from tblName where colName in (
select top 15(colName) from tblName order by colName asc
) order by colName desc

SQL Server 2005 contains enhancements that can handle such scenarios directly.

2007-02-27 18:25:37 · answer #1 · answered by Meena Ganesan 3 · 2⤊ 0⤋

Use LIMIT 5, 10

2007-02-27 18:14:02 · answer #2 · answered by shadowkat 5 · 0⤊ 0⤋

select * from blah limit 10 offset 5

2007-02-27 18:14:01 · answer #3 · answered by Vegan 7 · 0⤊ 0⤋

Use the query below...

2007-02-28 15:16:30 · answer #4 · answered by Ravi 2 · 0⤊ 0⤋

5,10

2007-02-27 18:26:44 · answer #5 · answered by ruchi s 3 · 0⤊ 0⤋