A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / sum
select * from employees where rownum between 100 and 120
| Is This Answer Correct ? | 2 Yes | 15 No |
Post New Answer View All Answers
Can we write dml inside a function in sql server?
What is the difference between a query and a report?
Why we use pl sql?
What are the different types of joins in sql?
what's the difference between a primary key and a unique key? : Sql dba
how do you tune the slow running queries in oracle db , explain the methodology
What is a full join?
What is pl/sql table? Why is it used?
How long does it take to learn pl sql?
Why we use stored procedure instead of query?
What is the difference between syntax error and runtime error?
what are date and time data types? : Sql dba
Can variables be used in sql statements?
How to write pl sql program in mysql command prompt?
What are the packages in pl sql?