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

How do I find duplicates in a single column in sql?

1022

Can sql function call stored procedure?

1025

What is meant by temporal data?

971

Which table is left in join?

983

Can 2 queries be executed simultaneously in a distributed database system?

1147

what is index? : Sql dba

1008

Does truncate remove indexes?

1038

What are the ddl commands?

1012

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1006

What is a recursive join sql?

1077

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

1038

What is sql indexing?

1013

How to call shell script from pl sql procedure?

1284

Is primary key is clustered index?

1002

What is rtm in testing?

1121