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
Which join is like an inner join?
How many types of primary keys are there?
what are all types of user defined functions? : Sql dba
What is package in pl sql with an examples?
What are the differences between in and exists clause?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Can we use join in subquery?
What is difference between my sql and sql?
What is the difference between inner join and left join?
Can I learn sql in a week?
How do I count duplicates in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What is the difference between a procedure and a function?
What is the difference between an inner and outer join?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?