Select min(sal) from table_name where sal in(Select top 2 sal from table

how to find the second highest salary from emp table?

Question Posted / velmurugan p

Answer Posted / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 sal from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is a table valued function object?

1009

Can we perform dml in function?

1063

How do I delete a trigger?

961

how to run 'mysql' commands from a batch file? : Sql dba

1110

What is difference between sql and excel?

1087

How do I debug a stored procedure?

1109

How many tables can you join in sql?

956

How do you update sql?

965

How to add new employee details in an employee_details table with the following details

1088

How can I tell if sql is running?

1064

What is a temporal table?

924

How to read/write files from pl/sql?

1035

What is parallel hint?

1315

What is primary key and unique key?

1113

Can we use ddl commands in pl sql?

1159