How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
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
Explain coalesce function?
How to save query output to a local file?
How to retrieve data from an cursor to a record?
What are a query and state the different types of queries and their uses?
How to export your own schema?
what is the use of system.effective.date variable in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
how the indexes are stored in the Oracle Database?
How to drop a stored procedure in oracle?
Explain the use of indexes option in exp command.
What does sharding mean?
How to end the current transaction in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to convert character types to numeric types?
What are temporal data types in oracle?