can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34154 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sandeep rana
Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the source of constraints?
How efficient you are in oracle and SQL server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Is it possible to have clustered index on separate drive from original table location?
What is a view in sql?
How can I check that whether automatic statistic update is enabled or not?
Why should you use or avoid select * statements?
How can we solve concurrency problems?
Does view occupy space?
What kind of problems occurs if we do not implement proper locking strategy?
How to provide default values to function parameters?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
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 acid mean in sql server?
Can we do dml on views?
