can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34139 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / darshan shah
select top 1 * from (select top 2 * from emp order by sal
desc ) a order by sal asc
Plz try this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 is spatial nonclustered index
How to convert numeric expression data types using the cast() function?
What is subquery? Explain the properties of a subquery?
What is a coalesce function?
List out the different types of locks available in sql server?
What are wait types?
Explain “row_number()” in sql server with an example?
What is self contained sub query?
Can you index views?
Why we use the openxml clause?
What is a view in sql?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we shrink data file in sql server?
Is it possible to have clustered index on separate drive from original table location?
