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 Redo Log Buffer in Oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is a system tablespace?
How to use select statement to count the number of rows in oracle?
What are the types of trigger in oracle?
What is a select query statement in oracle?
How to write a query with an inner join in oracle?
Explain rename?
How data locks are respected in oracle?
Give the different types of rollback segments.
Can the query output be sorted by multiple columns in oracle?
What is a schema in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Please explain joins in oracle?
How to add another datafile to a tablespace?