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
- 32661 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
What is ssrs?
List types of tables in SQL Azure?
What stored by the master? : sql server database administration
What is linked report?
What is a subquery in a select query statement in ms sql server?
How to defragment table indexes?
What is the security model used in sql server 2005?
How to transfer data from a cursor to variables with a "fetch" statement?
How do you handle datasets larger than 50 gb?
What is default constraint?
What is filter index?
How many types of triggers in sql server?
How to create a local temporary stored procedure?
What is the maximum length of an alert name?
What are different types of join?
