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
- 32369 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
In SQL Server 2000 Query:
-------------------------
select max(salary) from Employee where salary not in(select
max(salary) from employee)
This Query only selects the 2'nd Higehest Salary in that
table. So, you will try...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many null values we can have in a unique key field in sql server?
What is implicit cursors?
Determine when to use stored procedure to complete sql server tasks?
What is 'Join' and explain its various types.
Explain filtered indexes?
How to send a ssrs report from ssis?
Does windows server 2016 come with sql server?
What are different types of schemas?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is best institute to Learn DotNET And SQL in chennai?
What is a covering index?
What is a database in ms sql server?
What is PROJECTION Operation?
What is constraints and its types?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
