Interested to Buy Any Domain ? << Click Here >> for more details...
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 redo log?
How to drop an existing view in oracle?
What is recovery manager(rman) backup in Oracle?
How to open a cursor variable?
what are actual and formal parameters?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to delete a user account in oracle?
Explain the use of grant option in exp command.
What is the fastest query method to fetch data from the table?
How do you tell what your machine name is and what is its IP address?
How to use like conditions in oracle?
How to find the duplicate rows count from employees table in oracle?
What is a private synonym?
How to drop a tablespace?
How many file formats are supported to export data?
