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
Please Help Members By Posting Answers For Below Questions
How exception is different from error?
Can I call a procedure inside a function?
What is scalar function in sql?
Why is pl sql needed?
What are all ddl commands?
Is primary key an index?
What do you think about pl/sql?
What is the usage of the distinct keyword?
Explain architecture of sql server notification services?
What is using in sql?
what is a constraint? : Sql dba
Is delete faster than truncate?
What is the usage of when clause in trigger?
Can we change the table name in sql?
What is snowflake sql?
