A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / subhradeep
select * from employees where rownum<102
minus(select * from employees where rownum<81)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of procedures?
Explain how exception handling is done in advance pl/sql?
How can the performance of a trigger be improved?
Why should I use postgresql?
Which are the different types of indexes in sql?
how to add a new column to an existing table in mysql? : Sql dba
What does 0 mean in sql?
Write the command to remove all players named sachin from the players table.
What is trigger and types?
How many columns should be in an index?
Is sqlexception checked or unchecked?
What is normalization? How many normalization forms are there?
What are the built in functions of sql?
What are the string functions in sql?
what are different types of collation sensitivity? : Sql dba