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

how to find the second highest salary from emp table?

Question Posted / boring guy

Answer Posted / boring guy

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are data types in pl sql?

1076

Are null values same as that of zero or a blank space?

967

what is 'mysqlimport'? : Sql dba

974

what is log shipping? : Sql dba

1056

What are the different tcl commands in sql?

1103

Does inner join remove duplicates?

885

What is the difference between row level and statement level trigger?

958

Can you have a foreign key without a primary key?

900

Is sql a backend language?

1039

What is difference between stored procedure and trigger?

1058

what does it mean to have quoted_identifier on? : Sql dba

1099

Do we need to create index on primary key?

853

how to dump a table to a file with 'mysqldump'? : Sql dba

982

What is relationship? How many types of relationship are there?

1070

What are the differences between implicit and explicit cursors?

1003