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

10 Answers
18440 Views
Cognizant, Infosys, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

984

Explain acid?

1090

What is SQL Server?

1225

How to include text values in sql statements?

1047

How can we solve concurrency problems?

1062

Explain difference between control flow and data flow?

973

Explain alternate key, candidate key and composite key in sql server?

918

What is sql or structured query language?

1159

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2033

mention different types of relationships in the dbms?

1025

What is advantage data architect?

932

What is sub-query in sql server?

1212

Can binary strings be converted into numeric or float data types?

1046

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1077

How do you make a trace?

1031