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
- 11506 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 truncate?
What is the basic structure of an sql?
What is over () in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How to take user input in pl sql?
Are left and right joins the same?
Which nosql database is best?
Is progress software supports to ( pl/sql )?
What are two statement types in sql?
What are pl/sql cursor exceptions?
What is compiled query?
What is the difference between distinct and unique in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How does sql store data?
What is a native sql query?
