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
- 10701 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
Is sql a backend?
What are predefined functions in sql?
How do I make sql search faster?
how to get @@error and @@rowcount at the same time? : Sql dba
Is left join same as join?
what are the differences among rownum, rank and dense_rank? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Define overloaded procedure?
What is basic structure of pl sql?
What is a table partition?
explain access control lists. : Sql dba
What is trigger types of trigger?
What is natural join in sql?
What is embedded sql with example?
What is minus?
