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
What is a tns service name?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What happens to the current transaction if the session is ended?
Why is oracle used?
What is an Oracle index?
what is the difference between functional dependecy and multilevel dependency?
What types of joins are used in writing subqueries?
How to find the duplicate rows count from employees table in oracle?
How to filter out duplications in the returning rows using oracle?
How to best split csv strings in oracle 9i?
How to create a new table in your schema?
How do we create privileges in oracle?
What are the restrictions on external table columns?
Why do we need integrity constraints in a database?
Explain oracle data types with examples?