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
- 27659 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 can you do with pl sql?
How can I get the number of records affected by a stored procedure?
What does over partition by mean in sql?
Define concurrency control. : Transact sql
What are sql ddl commands?
What is rowid in sql?
Which sorts rows in sql?
How many postgresql users are there, worldwide?
What is dynamic sql in pl sql?
what are the advantages and disadvantages of views in a database? : Sql dba
What is mutating trigger?
What is compilation error in pl sql?
What is the difference between database trigger and stored procedure?
What is Histogram?
what is not null constraint? : Sql dba
