how to find the second highest salary from emp table?

Answer Posted / sathiavathi

select max(salary) from employee where salary!=(select max
(salary) from employee);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informix sql?

542


how to create a new table by selecting rows from another table in mysql? : Sql dba

565


What is the use of %rowtype?

541


Does postgresql run on the cloud?

595


What is sql architecture?

561






what is uncommittable transactions? : Transact sql

572


Explain what is table in a database?

590


What is an exception in pl/sql?

548


What is embedded sql what are its advantages?

509


what is the difference difference between procedure and packages

9235


What is difference between stored procedure and trigger?

541


Can we use distinct and group by together?

594


What is partition by in sql?

574


what is myisam? : Sql dba

582


How do I audit the sql sent to the server?

530