select min(select top(2)salary from emp)from emp;

how to calcuate the second highest salary of he employee

Question Posted / vivek ghorad

Answer Posted / vivek ghorad

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What are all the common sql functions?

971

What is a heap in sql?

994

What is cursor and why it is required?

1108

What is Difference Between Unique and Primary Key Constraints?

1060

List the ways to get the count of records in a table?

854

how to install mysql? : Sql dba

1047

what is the difference between truncate and delete statement? : Transact sql

1017

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

991

how would concatenate strings in mysql? : Sql dba

1016

What are different types of sql commands?

1026

Explain the commit statement.

1103

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1076

Explain clause in sql?

962

What is user defined functions?

918

What is difference between primary and secondary key?

976