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

What are variables in pl sql?

1094

what are the limitations of identity column? : Transact sql

1052

What is lookup table in sql?

982

What are stored procedures used for?

962

What is compiled query?

956

What is assignment operator in pl sql?

970

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1977

What are aggregate and scalar functions?

978

How would you pass hints to the sql processor?

922

Is primary key always clustered index?

948

How much does sql cost?

931

What is graph sql?

938

What is a system versioned table?

932

What is ttitle and btitle?

1008

How do you delete data from a table?

976