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
- 32686 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / harikumar
select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between createstatement and preparedstatement?
How to view existing indexes on an given table using sys.indexes?
Why use update_statistics command in sql server?
What is ms sql server service broker?
What is fill factor and pad index?
How to apply filtering criteria at group level with the having clause in ms sql server?
Can we write ddl in trigger?
How to grant a permission in ms sql server using "grant execute" statements?
What is page-level compression?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How much memory that we are using in Logshipping Concept?
What will be query used to get the list of triggers in a database?
What does REVERT do in SQL Server 2005?
In how many ways you can invoke ssrs reports?
What information is maintained within the msdb database?
