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
- 33542 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 correlated subquery in sql server?
Explain ms sql server reporting services vs crystal reports?
How to create a user name in a database?
How to assign null values to variables or columns?
How to create a view using data from another view?
what's the difference between delete table and truncate table commands? : Sql server database administration
How to drop an existing schema in ms sql server?
What is "scheduled jobs" or "scheduled tasks"?
how can u get last observation in an unknown dataset ?
How to return the second 5 rows in ms sql server?
Differentiate between delete and truncate.
What do you understand by mirroring?
Can primary key be a foreign key?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
How to provide values to stored procedure parameters in ms sql server?
