Answer Posted / chiru
select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between translate and replace?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to delete a column in an existing table in oracle?
What is the data pump import utility?
How to get execution statistics reports on query statements?
What are the uses of linked server and explain it in detail?
How to connect ms access to oracle servers?
How to assign a table row to a record variable?
what is the scenario where you take the database to NoArchivelog mode?
Explain the difference between replace() and translate() functions in oracle?
What is background process in Oracle?
how can we store any pdf file in oracle
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Is oracle the best database?
How to find out what oracle odbc drivers are installed?