can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 25004 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
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Does partitioning ssd reduce performance?
How to list all login names on the ms sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
What types of Joins are possible with Sql Server?
Describe the functionalities that views support.
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to return the date part only from a sql server datetime datatype?
How to use clusters?
What is not null constraint?
What is the difference between nvl and nvl2?
Which table keeps the locking information?
What is acid mean in sql server?
Explain about system database?
Do you know hot add cpu in sql server 2008?
