Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 33552 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
What is raiseerror? What is raiseerror?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What are the types of stored procedures in an sql server?
Explain what are magic tables in sql server?
Explain what is meant by replication of database?
How to find related tables in sql server?
What it means to be triggered?
What is the difference between char, varchar and nvarchar?
What is instead of dml trigger?
How to disable triggers using "disable trigger"?
What is 2nf normalization form?
What are the different types of cursor?
What is used to replicate sessions between instances in coldfusion clusters?
How to locate and take substrings with charindex() and substring() functions?
What do you mean by cardinality?
