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
- 32718 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 encryption key?
Write a code to select distinct records without using the DISTINCT keyword.
Do you know what is user defined datatypes and when you should go for them?
Can we take the full database backup in log shipping?
What is data compression?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain the microsoft sql server delete command?
When we should use @@error?
What is Federation Root Database?
What is pessimistic concurrency?
What is repeatable read?
How to download microsoft sql server 2005 express edition?
What is difference between foreign key and unique key?
What is an etl file?
How to change a login name in ms sql server?
