Answer Posted / g.sivanagaraju
SELECT DISTINCT(A.SAL)
FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
FROM EMP B
WHERE A.SAL<=B.SAL);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different parts of a package?
What are the different schemas objects that can be created using pl/sql?
Is primary key is clustered index?
When should I use nosql database?
Does pl/sql support create command?
Explain the difference between drop and truncate commands in sql?
How to handle bulk data?
Mention what are the benefits of pl/sql packages?
What are % type and % rowtype?
what is not null constraint? : Sql dba
How do I edit a trigger in sql developer?
How global cursor can be declare with dynamic trigger ?
What are the commands used in sql?
What is attribute indicator in pl sql?
Can a select statement fire a trigger?