select top 1 salary from emp where id not in (select top1 id from em

how to find the second highest salary from emp table?

Question Posted / rahul thakur

Answer Posted / rahul thakur

select top 1 salary from emp where id not in (select top1 id from emp order by salary desc)order by salary desc.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use having without group by in sql?

982

How to pronounce postgresql?

1057

What is #table in sql?

1094

how to shutdown mysql server? : Sql dba

1096

what are the properties and different types of sub-queries? : Sql dba

1032

What is aggregate function in sql?

1032

What is the command used to fetch first 5 characters of the string?

1396

what is data integrity? : Sql dba

1036

What is normalization in a database?

1152

What is the need of a partition key?

983

What are data types in pl sql?

1139

Can you skip header records while loading? : aql loader

1053

what are the types of subquery? : Sql dba

1102

What is synonyms?

1057

What is a heap in sql?

1067