how to find the second highest salary from emp table?
Answer Posted / hitesh pundir
select max(salary)from m1 where salary <>(select max(salary)
from m1)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are different types of triggers?
How to pronounce postgresql?
When are we going to use truncate and delete?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is varchar example?
Does sql full backup truncate logs?
When should I use nosql database?
What is the use of function in sql?
what is 'mysqlshow'? : Sql dba
Does sql between include endpoints?
What is pls integer?
What is program debugging?
How can you select unique records from a table?
What are inner and outer joins examples of both?
What is null in pl/sql?