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

how to find the second highest salary from emp table?

Question Posted / sudha

Answer Posted / sudha

select max(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

Which tcp/ip port does sql server run?

1014

What is the difference between syntax error and runtime error?

1143

what is sp_pkeys? : Transact sql

1162

What is a constraint? Tell me about its various levels.

1164

Explain table and field in sql?

1067

What is clause?

1156

What is the difference between function and procedure in pl/sql?

1091

What is the use of non clustered index?

996

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1095

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3572

Name the operator which is used in the query for pattern matching?

958

Can we insert data into view?

907

What is the difference between delete and truncate statement in sql?

1075

What is bind reference and how can it be created?

1021

What are few of the schema objects that are created using PL/SQL?

1040