can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34141 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the properties of the transaction?
What is the difference between upgrade and migration in sql server?
How efficient you are in oracle and SQL server?
List out the different types of locks available in sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is a view in sql?
What is normalization and what are the advantages of it?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is in place upgrade in sql server?
What are the kinds of subquery?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How do I find query history in sql server?
what is spatial nonclustered index
How do I start sql server 2017?
What is a scheduled job or what is a scheduled task?
