How to get second highest salary from a table

Answer Posted / senthil

select max(sal) from emp where sal <(select max(sal) from emp)

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql statements are used? Define them.

774


What are the types of subqueries?

768


What are records give examples?

743


Inline the values in PL/SQL, what does it mean.?

854


How delete all data from all tables in sql?

685






what is the syntax used for partition in tsql? : Transact sql

729


What is difference between hql and native sql?

777


what are the differences between binary and varbinary? : Sql dba

718


What is before trigger?

735


What is the trigger in sql?

700


What does cursor do in sql?

712


define sql insert statement ? : Sql dba

750


Why we use triggers in mysql?

726


Which join is like an inner join?

718


What is exit statement?

744