select max(department_id) from departments where department

how to find the second highest salary from emp table?

Question Posted / rajiv singh

Answer Posted / rajiv singh

select max(department_id) from departments where
department_id <(select max(department_id) from departments);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to use myisamchk to check or repair myisam tables? : Sql dba

972

Explain the rollback statement?

1016

What is the function that is used to transfer a pl/sql table log to a database table?

1031

Does truncate table reset auto increment?

1002

What is pragma in sql?

1086

What is record in pl sql?

1091

What is pl sql record in oracle?

1044

What is java sql drivermanager?

1104

How many triggers can be applied to a table?

1073

What is insert command in sql?

1139

What is count * in sql?

1001

Can we rollback delete command?

995

What is the advantage of nosql?

1066

how would concatenate strings in mysql? : Sql dba

1100

What are the operators in sql?

1036