SELECT * FROM TABLE WHERE columnName = (SELECT MAX(column

how to find the second highest salary from emp table?

Question Posted / rajkumar

Answer Posted / rajkumar

SELECT * FROM TABLE WHERE columnName =
(SELECT MAX(column_name) FROM TABLE WHERE
column_name<(SELECT max(column_name) FROM TABLE))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

1159

How do I remove all records from a table?

1075

Can we create clustered index without primary key?

964

What is string join?

979

Will truncate release space?

951

What are the different operators available in sql?

1000

How to check if a column is nullable before setting to nullable?

1128

What are field types?

1006

What is an exception in pl/sql?

1089

Explain what is a column in a table?

1107

What is benefit of creating memory optimized table?

972

what is a join? : Sql dba

1037

define join and explain different type of joins? : Sql dba

954

What is clause in sql?

1109

how can we repair a mysql table? : Sql dba

981