Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
- 3 Answers
- 5940 Views
- I also Faced
- E-Mail Answers
Answer Posted / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the logical operations?
Where do we use decode and case statements?
Explain index?
Does oracle partitioning improve performance?
Is insert autocommit in oracle?
Who developed oracle & when?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
various types of hints and their usage
What is Virtual Private Database in Oracle?
How do I manually uninstall oracle client?
what are bitmap indexes? How does they work?
Explain mutating triggers.
why dont we assign not null constraint as table level constraint.
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
