A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24575 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mohan
select * from table_name where rownum between 100 and 120;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do sql triggers work?
What has stored procedures in sql and how we can use it?
What is sql character function?
What does the argument [or replace] do?
where are cookies actually stored on the hard disk? : Sql dba
explain what is mysql? : Sql dba
What is the use of index in hive?
What is orm in sql?
What is difference between pl and sql?
Can we use ddl statements in stored procedure?
What is dml with example?
Explain normalization and what are the advantages of it?
What is data profiling in sql?
What is difference between hql and sql?
Why do we use joins?
