can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
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 are the requirements to use odbc connections in php scripts?
What is a collation in ms sql server?
Tell me about the approaches which you used to counter the DI problems.
How to turn off warning messages during php execution?
What are the features of Embedded SQL
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How to create a view with data from multiple tables?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
When would you use a before or after trigger?
what is the sql equivaent of the dataset relation object ?
How to create a dynamic cursor with the dynamic option?
What is the use of keyword with encryption. Create a store procedure with encryption?
What does it mean if @@cursor_row returns a negative number?
What is transactional replication?