Write a query to find second highest salary of an employee.
- 27 Answers
- 21877 Views
- I also Faced
- E-Mail Answers
Answer Posted / cooldude
select max(sal) from Emp where sal < (select max(sal) from
Emp)
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
define sql insert statement ? : Sql dba
What is sql injection vulnerability?
Can a procedure in a package be overloaded?
Is primary key clustered or nonclustered?
What are all the ddl commands?
how to install mysql? : Sql dba
What is form and report?
Can you have more than one trigger on a table?
how to convert character strings to numeric values? : Sql dba
What is sql and explain its components?
What are the different sql commands?
Do we need to rebuild index after truncate?
What is sql data?
What are pl/sql cursor exceptions?
What is the difference between cross join and natural join?
