can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 27877 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
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain triggers?
How to replace the Query Result 'Null Value' with a text ?
What are locks in sql?
How is SQL Azure different than SQL server?
What is sql server programming?
What program is used to store the data source file?
What is the difference between stored procedure and user defined functions?
what happens on checkpoint? : Sql server database administration
What is sharding?
What is a view in sql?
What are xml indexes?
Can I delete event logs?
What do you understand by hotfixes and patches in sql server?
How can I add Reporting Services reports to my application?
