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

how to find the second highest salary from emp table?

Question Posted / teja

Answer Posted / teja

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dialect in sql?

942

can sql servers linked to other servers like oracle? : Sql dba

1005

Explain polymorphism in pl/sql.

1113

Explain alias in sql?

1042

How do I run a script in sql developer?

944

Can we join tables without foreign key?

959

What is the importance of sqlcode and sqlerrm?

1354

What does closing a cursor do?

1313

How do you update a value in sql?

1043

How to run sql functions in pl/sql?

1052

What is trigger in sql and its types?

1055

What are expressions?

1011

How to write a query to show the details of a student from students table whose

994

What is pivot query?

1066

What is partition in sql query?

998