Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jaya u
SELECT A.EMPNAME ,A.SAL FROM EMP A
WHERE A.SAL = (SELECT DISTINCT (b.sal)
FROM EMP B WHERE ROWNUM = &N
ORDER BY B.SAL DESC );
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
what is Single Byte Overhead...?
What is a private synonym?
How many file formats are supported to export data?
Why do you use stored procedures and state some of its disadvantages?
What is rich query?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is the use of aggregate functions in oracle?
What is where clause in oracle?
What are the general rules on data consistency?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
State any two functions of oracle?
How a tablespace is related to data files?
What are the different types of synonyms?
What is the difference between a user and a schema in oracle?
