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


Please Help Members By Posting Answers For Below Questions

what are all the different normalizations? : Sql dba

509


If a cursor is open, how can we find in a pl/sql block?

676


what is union, minus and interact commands? : Sql dba

662


Can we use having without group by in sql?

553


Why is sql*loader direct path so fast?

601






Explain what is a database?

652


Is sql injection illegal?

597


How are functions and procedures called in PL/SQL?

593


What is string join?

559


What is transaction control language (tcl)?

637


how to drop an existing index in mysql? : Sql dba

541


What is pl sql code?

593


How to write pl sql program in mysql command prompt?

519


What is sqlca in db2?

536


define sql delete statement ? : Sql dba

560