select max(salary ) from emp table where sal<(select max (salary)from e

how to find the second highest salary from emp table?

Question Posted / pankaj raj patel

Answer Posted / pankaj raj patel

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a data manipulation language?

1024

What is pl sql architecture?

959

what is a unique key ? : Sql dba

1091

What are the benefits of pl sql?

1121

How do I view tables in mysql?

984

What is crud diagram?

946

How to place comments in pl/sql?

1156

which tcp/ip port does sql server run on? : Sql dba

1026

What are triggers and its uses?

1046

What is keys and its types?

1075

What is union?

1166

How do you explain an index number?

1106

Difference between truncate, delete and drop commands?

1082

What do you think about pl/sql?

1029

What is sql architecture?

1048