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

How to specify the collation for a character data type in ms sql server?

1089

What is format parameter in ssrs?

150

How to execute a sql statement using mssql_query()?

1105

What is sql profiler. What are the default templates with it? : sql server database administration

1108

What are truncate options available in sql server? : sql server database administration

1087

what is the maximum size of a row? : Sql server database administration

1082

What are partitioned views and distributed partitioned views?

1067

How much space does sql server 2016 take?

1033

Can you explain what are commit and rollback in sql?

986

What is the command used to check locks in microsoft sql server?

1103

What is the downside of using udf?

1163

What is transaction server auto commit?

1117

how would you store your query in an SSRS report or a Database server?

167

Explain sql delete command?

1092

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1083