How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
- 2 Answers
- 4874 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
How to use "for" statements in oracle?
What is a procedure in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to use "out" parameter properly?
How to start a specific oracle instance?
What is dual table oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is the data type of dual table?
How to rebuild an index in oracle?
What is where clause in oracle?
What is the difference between a hot backup and a cold backup in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Why does Oracle not permit the use of PCTUSED with indexes?
What is a package in oracle?
How to convert raw data type into text in oracle? Explain
