can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / harikumar
select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to populate a table in sql server?
Explain about nested stored procedure?
What is normalization process?
Which are ddl commands?
What does it mean to be in union?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What do you understand by a stored procedure?
Explain throw statement in sql server 2008?
What is an execution plan?
How you can move data or databases between servers and databases in sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
What is the use of nvl work?
Why I am getting this error when dropping a database in ms sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is service broker? : sql server database administration