A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / laks
select * from emp where rownum<121
minus(select * from emp where rownum<101)
| Is This Answer Correct ? | 34 Yes | 4 No |
Post New Answer View All Answers
Is oracle and sql same?
Which data dictionary views have the information on the triggers that are available in the database?
What is a call statement? Explain with an example.
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Is clustered index a primary key?
Are subqueries better than joins?
What is Materialized View? In What Scenario we Use Materialized View?
What is cursor in pl sql with examples?
What are aggregate and scalar functions?
what are the differences between char and nchar? : Sql dba
What are variables in pl sql?
How to display the current date in sql?
Why do we use procedures in sql?
What is the source code of a program?
What is microsoft t sql?