Interested to Buy Any Domain ? << Click Here >> for more details...
A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 26875 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
Is the primary key an index?
What can you do with pl sql?
How to look at the current sql*plus system settings?
Is pl sql still used?
What is user in sql?
what is a table in a database ? : Sql dba
How can we store rows in PL/SQL using array?
what is 'trigger' in sql? : Sql dba
What does fetching a cursor do?
what is self join and what is the requirement of self join? : Sql dba
What is a trigger in sql?
What are the types of join and explain each?
How do you modify a trigger?
what is log shipping? : Sql dba
Can you upgrade sql express to full sql?
