Interested to Buy Any Domain ? << Click Here >> for more details...
suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary
- 7 Answers
- 12910 Views
- I also Faced
- E-Mail Answers
Answer Posted / umesh h
Use Minus Operator
select * from emp where rownum<=101
minus
select * from emp where rownum<=100;
Here minus will display data only from first query minusing
from 2 query.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is sql query limit?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to move files from one directory to another in pl sql?
What are the qualities of 2nf?
Can we use view in stored procedure?
What are all different types of collation sensitivity?
Where do we use pl sql?
How to pipe multiline string to isql?
What are the different types of dbmss?
Can you have more than one key in a database?
What is sqlca in db2?
What are different categories of sql commands?
Which sorts rows in sql?
What is denormalization in a database?
How many sectors are in a partition?
