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
- 33530 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / elumalai.k
select max(salary)from tablename where salary <(select
max(salary)from tablename)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is in place upgrade in sql server?
How many partitions a clustered index has by default in sql server 2012?
What is the purpose of forms?
What is msdb database? : SQL Server Architecture
What is failover clustering overview?
Explain aggregate functions?
How to create a new table in a given schema?
What is trigger and different types of Triggers?
What is data modification?
Explain the Ways to improve the performance of a sql azure database?
What is the impact on other user sessions when creating indexes?
What xml support does the sql server extend?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to create dbo table in sql server?
Explain the difference between primary keys and foreign keys?
