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
How to delete a column in an existing table?
How to use group functions in the select clause using oracle?
How do I find my oracle client driver version?
How do I limit the number of oracle database connections generated by weblogic server?
Can you have more than one content canvas view attached with a window ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is system tablespace?
What is the difference between primary key and unique key and foreign key in oracle?
What are a cluster and non-cluster index?
How to delete a column in an existing table in oracle?
Explain the types of exception?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Give the various exception types.
Explain how are indexes update?
What is the difference between postgresql and oracle?