select max(salary) from Employee where salary<(SELECT max(salary) from

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

Question Posted / siva kumar yachamaneni

Answer Posted / siva kumar yachamaneni

select max(salary) from Employee where salary<(SELECT
max(salary) from Employee)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can cursors be part of a trigger body?

1693

What is the non-clustered index in sql?

1107

How do you declare a user-defined exception?

1076

Are left and right joins the same?

1158

how to run 'mysql' commands from a batch file? : Sql dba

1170

What is null in pl/sql?

1121

How do you identify a primary key?

1114

What is parameter substitution in sql?

1081

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3623

What are string functions in sql?

1305

What is before and after trigger?

1010

What does dml mean?

1043

What is dcl in sql?

1024

Describe different types of general function used in sql?

1092

What does select count (*) mean in sql?

1075