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

Can one improve the performance of sql*loader? : aql loader

1046

Can we create table inside stored procedure?

950

How do I create an index in word?

1029

What is a pragma statement?

1262

What is a design view?

921

what is sql? : Sql dba

1023

What is pl/sql table? Why it is used?

1033

How do I make sql search faster?

995

Can I call a procedure inside a function?

1008

how mysql optimizes distinct? : Sql dba

1076

Is delete faster than truncate?

1002

what is the difference between char and varchar data types? : Sql dba

1098

what is data manipulation language? : Sql dba

1012

What is a full join sql?

1054

What is difference between cursor and trigger?

1070