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

How to get help at the sql prompt?

1111

How global cursor can be declare with dynamic trigger ?

2206

What is a dynamic query?

1018

Can you join a table to itself?

1122

Can we call stored procedure in function?

956

Do stored procedures prevent sql injection?

966

What is pl sql record in oracle?

1026

How do you delete duplicates in sql query using rowid?

944

What is bind reference and how can it be created?

1014

How can I delete duplicate rows?

1010

what is the difference between a local and a global temporary table? : Sql dba

1070

How do I run a query in pl sql developer?

991

What is the maximum database size for sql express?

1019

Is left join faster than inner join?

1120

what is user defined functions? : Sql dba

1027