select top1 salary from(select distinct top2 salary from table name order

how to find the second salary?

Question Posted / raja

Answer Posted / raja

select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain nested join?

989

What is mssql?

987

How do I find the size of a sql server database?

929

What are different types of roles provided by ssrs?

151

How to encrypt data between dialogs?

1114

What are binary string data types in ms sql server?

1300

What is ms sql server index?

1109

How to recreate an existing index in ms sql server?

1060

Tell me what is a linked server?

1040

How to change the system date and time from SQL Plus Terminal ?

1223

What protocol does sql server use?

948

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1012

What is the sql case statement used for? Explain with an example?

996

What are the properties of sub-query?

1074

Explain tables in SQL Azure?

120