can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34122 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / mahesh
Select max(sal) from emp
where id='1233' and Sal< (select max(sal) from emp)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between for xml raw and for xml auto?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How can you append an identity column to a temporary table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the different types of subquery?
Why and when do stored procedure recompile?
Explain “row_number()” in sql server with an example?
Equi join and non equi join is possible with sql server?
What is a scheduled job or what is a scheduled task?
Why we use the openxml clause?
What is the difference between upgrade and migration in sql server?
Where can you add custom error messages to sql server?
What is acid mean in sql server?
How to remove duplicate rows from table except one?
Why should you use or avoid select * statements?
