Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 33548 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / harikumar
select max(salary) as secondMax from employee where salary
<> (select max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to do partition in sqlserver
Do you know what is user defined datatypes and when you should go for them?
How to convert numeric expression data types by assignment operations?
What do you mean by sql server 2005 express management tools?
What are statistics?
What do you understand by hotfixes and patches in sql server?
How to write character string constants or literals in ms sql server?
What are extended events in sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are scheduled tasks in sql server?
What is difference between count (*) and count 1?
What do you think of this implementation? Can this be implemented better?
What are different types of raid configurations? : SQL Server Architecture
What is order of B+tree?
Tell me what are the essential components of sql server service broker?
