A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24627 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sagar sananse
with admitCTE(AdmissionId,PatientId,RN) as
(
select AdmissionId,PatientId,Row_number() over (order by AdmissionId) as RN from tempadmit
)
select * from admitCTE where RN between 101 and 120
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of keys are there in sql?
Explain locks? : Transact sql
How to connect a sql*plus session to an oracle server?
What are the two characteristics of a primary key?
Why do we use joins?
What are the qualities of 2nf?
How do you bind variables in pl sql?
What is the usage of the distinct keyword?
What is the location of pre_defined_functions.
What is pls_integer in pl sql?
Define join and name different types of joins?
Why do we use partitions in sql?
What are the different dml commands in sql?
What is sqlcontext?
What does select count (*) mean in sql?
