with temp as ( select row_number() over(order by city) rowid, * from e

How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Question Posted / shilpa

Answer Posted / shilpa

with temp
as
( select row_number() over(order by city) rowid, * from
employee)
select * from temp
where rowid >= 10
and rowid <= 20

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me in brief how sql server enhances scalability of the database system?

1040

how to do partition in sqlserver

2547

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1117

What is the default sql server instance name?

1088

What is a primary index?

977

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1154

what is the maximum size of a row? : Sql server database administration

1080

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1873

What is replace and stuff function in sql server?

1114

What is the fillfactor concept in indexes?

1035

How extra digits are handled with numeric data type literals?

1031

New concepts of sql server 2005 use in your project.

2401

What is implicit cursors?

1133

How to select an exiting database using mssql_select_db()?

1053

Explain intellisense for query editing

1076