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

What is the syntax to execute the sys.dm_db_missing_index_details?

1013

What is primary key, unique key, and foreign key?

965

What are different type of Collation Sensitivity?

994

how many clustered indexes can be created on a table? : Sql server database administration

1139

How to write a query with a left outer join in ms sql server?

967

Why use triggers?

1003

What are data driven subscriptions?

112

How can a database be repaired?

982

What is 2nf normalization form?

1125

Can we deploy SSRS reports on our personal website?

168

What is difference between join and natural join?

957

What are the types of lock supported by ?

1037

What is etl - extraction, transformation, and loading?

913

What is the difference RDBMS and Graph Database?

1041

What is the contrast between sql and mysql?

1102