select sal from emp where sal=(select max(sal) from emp where sal<(sele

how to calcuate the second highest salary of he employee

Question Posted / shailesh

Answer Posted / shailesh

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of double ampersand (&&) in sql queries? Give an example

1082

Why is the cursor important?

979

What is the difference between microsoft sql and mysql?

921

What is the basic form of sql query?

881

What is character functions?

1017

What does dml mean?

930

How to select random rows from a table?

1023

What is sqlerrm?

883

Can triggers stop a dml statement from executing on a table?

1027

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1095

Can you have a foreign key without a primary key?

902

What is difference between nchar and nvarchar?

958

What is union?

1085

How will you distinguish a global variable with a local variable in pl/sql?

1093

How to create an array in pl/sql?

1015