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
- 12700 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 a left inner join?
How does sql developer connect to oracle database?
Define commit, rollback and savepoint?
Why is theta join required?
What is a schema? How is it useful in sql servers?
What is the difference between sql and t sql?
Does sql support programming?
What is delimiter sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Which join is default?
What is bulk collect in pl sql?
What are tables in sql?
Write an sql query to select all records from the table?
How is sql used in oracle?
Is primary key clustered or nonclustered?
