select max(salary) from table_name where sal<(select max(salary) from t

how to find the second highest salary from emp table?

Question Posted / arvind

Answer Posted / arvind

select max(salary) from table_name where sal<(select
max(salary) from table_name)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the use of friend function? : Sql dba

1063

What are the topics in pl sql?

1024

what is union? : Sql dba

1082

Do we need to create index on primary key?

966

Can dml statements be used in pl/sql?

1125

What is sql architecture?

1102

What is a design view?

978

What are the limitations of sql express?

1122

What are the datatypes available in pl/sql ?

1155

Does truncate require commit?

1034

I need a function for a train ticket reservation please answer it thanks in advance

1078

What is the difference between partition and index?

1062

What is data types in sql?

1070

Can function return multiple values in sql?

1099

Can cursors be part of a trigger body?

1693