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 is the requirement of self-join?

1217

Explain scalar functions in sql?

1112

What are the methods of filing?

996

Explain the methods used to protect source code of pl/sql.

1078

What is rank function in sql?

1074

Can we create foreign key without primary key?

1045

Explain lock escalation? : Transact sql

1289

How does postgresql compare to "nosql"?

1088

What is linq to sql?

1185

What is $$ in sql?

1049

What is the example of procedure?

979

How do you declare a constant?

1019

how to use in conditions? : Sql dba

1069

What is compilation error in pl sql?

1027

How do I pipe the output of one isql to another?

1063