select max(salary) from employee where salary

how to find the second highest salary from emp table?

Question Posted / ashwini

Answer Posted / ashwini

select max(salary) from employee where salary < (select max(salary) from employee)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1058

how are mysql timestamps seen to a user? : Sql dba

1139

What is varchar used for?

1074

How do you rank data in sql?

1001

Is left join inner or outer by default?

1019

What is sqlca in db2?

952

How to get unique records from a table?

961

How to rename a column in the output of sql query?

1072

Why function is used in sql?

941

What is partition in sql query?

998

Is join an inner join?

963

Explain what is dbms?

1055

Can a table have no primary key?

1059

Is pl sql better than sql?

1028

Explain the difference between drop and truncate commands in sql?

1046