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

How do I use google cloud in sql?

1091

What is offset and limit in sql?

1059

What is java sql package?

1097

How to run sql*plus commands in sql developer?

1159

What are the different set operators available in sql?

1026

How can one get sql*loader to commit only at the end of the load file? : aql loader

1059

What does t sql mean?

949

Why do we use triggers?

968

What are all the different normalizations?

1033

How can I make sql query run faster?

1017

How do I run a query in pl sql developer?

996

what is the difference between inner and outer join? Explain with example. : Sql dba

1026

What are some emotional triggers?

985

What is a system versioned table?

987

What is rank () in sql?

942