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

how to find the second highest salary from emp table?

Question Posted / kiran

Answer Posted / kiran

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

/

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a natural join sql?

922

what is a field in a database ? : Sql dba

991

What if we write return in procedure?

1336

How to sort the rows in sql.

1011

How do I debug a stored procedure?

1042

How to read xml file in oracle pl sql?

862

What is a variable in sql?

953

How do I copy a table in sql?

931

How to fix oracle error ora-00942: table or view does not exist

958

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

1018

Is sql harder than python?

1039

Where can I learn sql for free?

933

what is offset-fetch filter in tsql? : Transact sql

893

How do I save the results of sql query in a file?

929

what are set operators in sql? : Sql dba

985