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
- 10668 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
How do you modify a table in sql?
What is synchronized subquery?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What are the 3 types of behavioral triggers?
how to fetch alternate records from a table? : Sql dba
What is sql lookup?
Does sql support programming?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is the max nvarchar size?
What are the usages of sql?
Why functions are used in sql?
What is set serveroutput on?
What is sql exception?
how can we know the number of days between two given dates using mysql? : Sql dba
What is cascade in sql?
