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's sql server? : Sql server database administration

500

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

503

How do I determine how many instances of sql server are installed on a computer?

535

Is the order of columns in the set clause important in ms sql server?

521

What is dml command?

547

How to find related tables in sql server?

501

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

540

What are the recovery models for a database?

618

List out a number of the wants to setup a SQL Server failover cluster?

583

What is difference between table aliases and column aliases? Do they affect performance?

506

Working with TLogs

1450

What are the events recorded in a transaction log?

508

What is the full form of dql?

515

What is merge statement?

628

What is database white box testing?

677