can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / rajendra
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is normalization and denormalization in sql server?
Which are the third-party tools used in sql server and why would you use them?
How optimize sql query with multiple joins in sql server?
What is CTE in SQL
What are the filtered indexes?
What are SSL and TSL protocols?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is a partition key?
What is use of @@ spid in sql server?
What is the correct order of the logical query processing phases?
Do you know the cursor types?
Explain left outer join and right outer join?
Are connections to sql server encrypted?
Explain the third normal form(3nf)?
How do you create an execution plan?