can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 27837 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / divya
select max(sal) from tablename where sal<(select
max(sal)from tablename)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is after dml trigger?
Tell me what is a linked server?
What is the difference between Normalization and De-normalization?
When you should use a low fill factor?
What are the requirements to use odbc connections in php scripts?
Why would you use sql agent?
What is optimization and its types?
What is service broker? : sql server database administration
explain databases and sql server databases architecture? : Sql server database administration
How do you create a data source?
How to test values returned by a subquery with the in operator?
Explain the dirty pages?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the difference between dropping a database and taking a database offline?
What is difference between order by and group by?
