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

Does sql full backup truncate logs?

968

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

What is the purpose of cursors in pl/sql?

1081

how to enter binary numbers in sql statements? : Sql dba

923

what are the types of subquery? : Sql dba

1053

Explain table and field in sql?

1016

How do I create a memory optimized filegroup?

906

What is microsoft t sql?

882

What is a sql trace file?

979

What is break?

1141

Explain what is sql*plus?

1087

How can a pl sql block be executed?

891

What is type and rowtype in pl sql?

968

What is sharding in sql?

918

Can we create index on primary key?

916