1 My Second Answer. Select Top 1 * From Tablename where salary in (sele

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / kumar

Answer Posted / kumar

1 My Second Answer.

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc.

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I start sql server 2017?

988

what is a join? : Sql server database administration

1328

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

141

Define model database?

1033

What are the five major components of a dbms?

962

How to encrypt Strored Procedure in SQL SERVER?

1230

What are 3 ways to get a count of the number of records in a table?

1122

What is a bit datatype?

1022

How to create an inline table-valued function?

1023

Describe in brief sql server monitoring ways.

1103

When would you use a before or after trigger?

958

How do you send email on SQL Server?

1119

What are the methods used to protect against sql injection attack?

1120

Name three of the features managed by the surface area configuration tool? : sql server security

1034

Tell me what is the order in which the sql query is executed?

1018