Select min(sal) from table_name where sal in(Select top 2 sal from table

how to find the second highest salary from emp table?

Question Posted / velmurugan p

Answer Posted / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 sal from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning and sharding?

1053

What does fetching a cursor do?

1133

Is sql microsoft?

1108

How do I run a program in pl sql?

1055

What is the primary use of normalization?

1054

What are the possible values that can be stored in a boolean data field?

1043

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1228

How long does it take to learn pl sql?

1107

what is the difference between a web-garden and a web-farm? : Sql dba

1145

Whis is not false in primary key?

1526

What are local and global Indexes and where they are useful.

1495

What is difference between group by and partition by?

1129

What does sql stand for?

1055

What is a constraint?

1085

What is the primary key?

1003