can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 24919 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 are system databases into sql server (2005/2008) : sql server database administration
In what three ways is the return statement used in a stored procedure?
What information is maintained within the msdb database?
What happens if strings are casted into wrong code pages in ms sql server?
How will you decide the active and passive nodes?
How to perform backup for certificates in sql server? : sql server security
What is candidate key with example?
What stored procedure can you use to display the current processes?
What is difference between index and primary key?
What is #table in sql server?
What do mean by xml datatype?
How to execute a sql statement using odbc_exec()?
What is ssl in sql server?
What is clustered primary key?
What does man by sql wildcard characters in sql server?
