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

how to find the second highest salary from emp table?

Question Posted / kameshwar shukla(a.i.e.t l.k.o

Answer Posted / kameshwar shukla(a.i.e.t l.k.o

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 is a unique constraint?

1067

what are date and time intervals? : Sql dba

1057

Does sql require a server?

1007

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

997

What are synonyms in sql?

970

What are the advantages of pl sql?

1122

what is the difference difference between procedure and packages

10399

Explain character-manipulation functions?

1125

How to display Row Number with Records in Oracle SQL Plus?

1043

Why is stored procedure faster than query?

960

What is the best free sql database?

1049

What are different types of tables in sql?

996

how to add a new column to an existing table in mysql? : Sql dba

1066

Can you inner join the same table?

988

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

1065