select max(salary) from table where salary < (select max(salary) from t

how to get second highest salary in SQL(as/4000

Question Posted / dharmendra

Answer Posted / dharmendra

select max(salary) from table
where salary < (select max(salary) from table);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can I change database name in sql?

1157

Why do we use set serveroutput on?

1014

How to move files from one directory to another in pl sql?

1252

Is sql pronounced sequel or sql?

1339

Why left join is used in sql?

1019

What type of database is sql?

1067

What is application trigger?

1056

what are all the different normalizations? : Sql dba

1121

What is execute immediate?

1163

Why use subqueries instead of joins?

1136

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

what is a constraint? Tell me about its various levels. : Sql dba

1049

What is embedded sql with example?

1099

How to connect a sql*plus session to an oracle server?

1175