can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 25166 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 the meaning of lock escalation and why/how to stop this? : sql server database administration
How to start sql server browser service?
Give a example to search fr a string in all stored procedure in sql server.
Where is localdb stored?
List the different normalization forms?
How can a user-defined datatype be created?
Why I have to use stored procedures?
What is the meaning of resultset type_scroll_insensitive?
How ssrs maintain security?
What are joins in sql and what are the different types of joins?
Explain unique key in sql server?
Are connections to sql server encrypted?
What is exclusive locks?
What is the difference between sdf and mdf?
How to delete duplicate rows from table except one?
