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
- 27443 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
What is difference between sql and oracle?
what is a trigger? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What are the different types of functions in sql?
how to include character strings in sql statements? : Sql dba
Can we use pl sql in mysql?
what are the advantages of sql ? : Sql dba
Can we group by two columns in sql?
What are different types of keys?
What is compound trigger?
What is a join?
Explain the the update statement in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Is delete faster than truncate?
What are keys in sql?
