Write a query to find second highest salary of an employee.
Answer Posted / manikumar
Select Sal from Emp where Sal in (Select Max(Sal) from Emp)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are all the different normalizations? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
what is union, minus and interact commands? : Sql dba
Can we use having without group by in sql?
Why is sql*loader direct path so fast?
Explain what is a database?
Is sql injection illegal?
How are functions and procedures called in PL/SQL?
What is string join?
What is transaction control language (tcl)?
how to drop an existing index in mysql? : Sql dba
What is pl sql code?
How to write pl sql program in mysql command prompt?
What is sqlca in db2?
define sql delete statement ? : Sql dba