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

What is parallel hint?

1315

What is oracle sql called?

922

What is restrict in sql?

1107

How can you load multi line records? : aql loader

1071

What are all ddl commands?

1080

How do I delete a trigger?

961

What is varchar sql?

1131

What does the sign mean in sql?

984

What are the indexing methods?

1039

What types of commands can be executed in sql*plus?

1107

How can you select unique records from a table?

1070

What is the difference between cross join and natural join?

1014

what is 'mysqld'? : Sql dba

964

What is the life of an sql statement?

1016

Why do we use triggers?

963