how to get second highest salary in SQL(as/4000

Answer Posted / deepak

select max(sal) from emp where sal!=(select max(sal) from emp);

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql*plus?

573


What are the various levels of constraints?

666


What is null in pl/sql?

626


Which is faster count (*) or count 1?

542


what are date and time data types? : Sql dba

539






What are views in sql?

547


What is the best partition size for windows 10?

487


What are different sql data types?

513


What are the indexing methods?

577


What is procedure explain with example?

542


What is an alias command?

576


What is bulk compiling in pl/sql.?

611


What jobs use sql?

531


What is varray in pl sql?

566


How do I send sql query results to excel?

581