can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34125 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kavitha.r
This query is generalised query if u replace 2 by 100 ,
then you will get 100th max salary
select top 1 salary from employee where salary in( select
top 2 salary from employee order by salary desc) order by
salary asc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How raid can influence database performance?
what is the difference between openrowset and openquery?
What is sql server query analyzer?
What is acid mean in sql server?
How to connect php with different port numbers?
Can sql servers link to other servers like oracle?
How do I create a trace in sql server?
How do I find the sql server version?
Is it possible to have clustered index on separate drive from original table location?
What is in place upgrade in sql server?
How to provide default values to function parameters?
How do I start sql server 2017?
Explain system functions or built-in functions? What are different types of system functions?
What is a coalesce function?
Why should you use or avoid select * statements?
