can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34157 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / dhaval
we have to use distinct key word there is a possibility
that two person having same salary.
select top 1 sry from (select distinct top 2 sry from emp
order by sry desc)t1 order by sry asc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
What is sql or structured query language?
Why and when do stored procedure recompile?
List out the different types of locks available in sql server?
What is a scheduled job or what is a scheduled task?
How do I create a trace in sql server?
How can you append an identity column to a temporary table?
What are the source of constraints?
What is in place upgrade in sql server?
What are the different subsets of sql?
Explain “row_number()” in sql server with an example?
Where can you add custom error messages to sql server?
Why should you use or avoid select * statements?
What are the different types of subquery?
How do I find query history in sql server?
