0

Hi
i am using c# as my language & sql server as my database ..
My question is there is no key ward called

limit

in sqlserver....how i solve this type of question...

the example is --->
the sql server data table has 25 rows & i want to retrieve 6 to 11 data rows...How i write sql code in sql server to get that rows

thank U

3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by iamchamith
0

thanks for reply answer for my question...buy not solve that
I use sqlserver 2005...when i use sql code as

SELECT * FROM `student` LIMIT 20, 10

there is a error occur...in that error message box show Unable to parse query text...The quary cannit be representer int the diagram and Criteria Pane
What am i do ???
Please help me

0
SELECT * FROM
(
SELECT row_number() OVER (ORDER BY AnyColumn) AS rownum, Column1,Column2, ..., ColumnX
FROM   YourTable) AS A
WHERE A.rownum BETWEEN 10 AND 20

Ionut

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.