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
- 12676 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 are sql commands classified?
Define select, insert, create, delete, update, drop keywords
Where can I learn sql for free?
Can you call pl/sql package functions from within a fast formula?
what happens if null values are involved in expressions? : Sql dba
What is embedded sql what are its advantages?
How do you update f as m and m as f from the below table testtable?
Can we commit in trigger?
How to look at the current sql*plus system settings?
Can we use update in sql function?
Do prepared statements prevent sql injection?
What is %type in sql?
Show the cursor attributes of pl/sql.
Is mariadb nosql?
Does a user_objects view have an entry for a trigger?
