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
How many types of tables supported by oracle?
What is java oracle used for?
Explain what does a control file contain?
What is max rowid in oracle?
What privilege is needed for a user to create indexes in oracle?
How to assign query results to variables?
What is the difference between primary key and unique key and foreign key in oracle?
How to get a create statement for an existing table?
Explain a data segment?
What are the attributes of the cursor?
What is null value in oracle?
How to create a table index?
What is a user account in oracle?
How to check your oracle database 10g xe installation?
How do I use unicode codesets with the weblogic jdriver for oracle driver?