limit clause in MS SQL

[Kuladip Yadav]

Hi Ranchers,

There is limit clause in MY SQL wich get specfic number of records from
specific row.
How we can achieve this in MS SQL Server 2000.

Any Link appreciated.

Thanks
- Kuldeep

[Paul Sturrock]

MS SQL has the "top" keyword, e.g. :

select top 10 * from table

will get you the first ten results from that table.
[ November 05, 2008: Message edited by: Paul Sturrock ]

[Kuladip Yadav]

Hi Paul,

MS SQL has the "top" keyword,

Your are right but if I want records from
10 to 15 then how should i get it ?

[Kaleeswaran Karuppasamy]

Originally posted by Kuldeep Yadav:
Hi Paul,



Your are right but if I want records from
10 to 15 then how should i get it ?

SELECT custid
FROM (SELECT TOP (2) custid
FROM (SELECT TOP (3) custid
FROM customer) AS foo
ORDER BY custid DESC) AS bar
ORDER BY custid

x is the number of rows you want returned and y is x+offset.

[Kuladip Yadav]

Hi Kaleeswaran,

Thanks for your solution . It gives me required result.
I want to use this solution for different tables. So
I have 2 way for implementing this solution

To create prepared Statement for this query and using it

Creating stored procedure for it .and called it fro java code

Which one is better ?

Thanks
- Kuldeep
[ November 05, 2008: Message edited by: Kuldeep Yadav ]