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


Please Help Members By Posting Answers For Below Questions

Explain coalesce function?

741


How to save query output to a local file?

688


How to retrieve data from an cursor to a record?

668


What are a query and state the different types of queries and their uses?

606


How to export your own schema?

685






what is the use of system.effective.date variable in oracle?

785


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1733


how the indexes are stored in the Oracle Database?

1844


How to drop a stored procedure in oracle?

693


Explain the use of indexes option in exp command.

695


What does sharding mean?

660


How to end the current transaction in oracle?

683


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1312


How to convert character types to numeric types?

693


What are temporal data types in oracle?

716