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
- 12600 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 does trigger mean in psychology?
How does sql developer connect to oracle database?
Does sql profiler affect performance?
What are operators available in sql?
What is the difference between syntax error and runtime error?
how to start mysql server? : Sql dba
How is a process of pl/sql compiled?
What is sql comments?
What are different methods to trace the pl/sql code?
What is sql partition?
What is audit logout in sql profiler?
What is dml and ddl?
What is sql performance tuning?
How can I delete duplicate rows?
How to run sql functions in pl/sql?
