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
- 28328 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 long does it take to learn pl sql?
What is thread join () in threading?
Explain what is rdbms?
What jobs use sql?
Can a varchar be a primary key?
How to return multiple rows from the stored procedure?
What are pl sql procedures?
Can we call a function containing dml statements in a select query?
What are sql built in functions?
Explain what is a database?
How to rename a table?
Is null operator in sql?
What are the advantages of pl sql over sql?
What are the ways on commenting in a pl/sql code?
What is sqlite format?
