Answer Posted / bharath
select e1.* from emp e1
where &n=
(select count(distinct(*))
from emp e2
where e2.sal>e1.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is columnar storage what is the advantage?
How to use group functions in the select clause using oracle?
how to clone 9i Database on to 10g Database.
How to use select statement to count the number of rows in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a system tablespace and when it is created?
what is port in oracle? how is it related to database application.
What is a package ? What are the advantages of package ?
How to create a new view in oracle?
Explain enable novalidate constraint.
What is the minimum client footprint required to connect c# to an oracle database?
What are the differences between number and binary_float in oracle?
How to convert times to characters in oracle?
How many types of database triggers exist?
What does sharding mean?