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
how to rename an existing table in mysql? : Sql dba
How do you break a loop in pl sql?
What is case function?
How do I view output in sql developer?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Why is sharding used?
How do I view a table in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is sql lookup?
what is the different between now() and current_date()? : Sql dba
What is benefit of creating memory optimized table?
Can I create table without primary key?
How do I find sql profiler?
Can a view be mutating? If yes, then how?