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 is data definition language?
What are sql built in functions?
What is java sql connection?
What is a unique key and primary key and foreign key?
What is the usage of when clause in trigger?
Explain the update statement in sql
What is the meaning of disabling a trigger?
tell me about various levels of constraint. : Sql dba
How many clustered indexes can be created on a table?
Does user triggers have entry for trigger with compilation errors?
How do you write a complex sql query?
How do you use join?
How are sql commands classified?
What is the use of double ampersand (&&) in sql queries? Give an example
Can a foreign key be null?