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
- 33523 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kumar_kisna
select max(salary) from table where salary<(select max
(salary) from table)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is isnull() operator?
What is Command line parameters in PLSQL.?
Can we use where and having clause together?
How self join is different from outer join?
What is the difference between coalesce() & isnull()?
What are sp_configure commands and set commands?
What are two difference between sql azure and azure tables?
How to list all schemas in a database?
How do I find the sql server version?
What are the two authentication modes in sql server?
How do clustered indexes store data?
Is sql server a database?
What are the different sql server versions?
Can you explain the disadvantages/limitation of the cursor?
State a few properties of relational databases?
