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
- 12370 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
when is the use of update_statistics command? : Sql dba
what is sql in mysql? : Sql dba
what is schema? : Sql dba
How do you update a value in sql?
How do you delete data from a table?
What is an implicit commit?
What are the different sql languages?
Is sql a microsoft product?
What is query execution plan in sql?
how are mysql timestamps seen to a user? : Sql dba
What is the difference between microsoft access and sql?
What is oracle sql developer?
Can we create index on primary key?
how many triggers are allowed in mysql table? : Sql dba
What is program debugging?
