can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 28079 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / dileep.t
If you need the second highest salary only
then following will also work,
select Max(Salary) from TableName
where Salary not in(
Select Max(Salary) from TableName)
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
What is the Control Flow in SSIS
What is a sql join?
how can u get last observation in an unknown dataset ?
Explain what is raid and what are different types of raid levels?
Why olap is used?
After removing a table from database, what other related objects have to be dropped explicitly?
Explain log shipping and mention its advantages.
Explain the rules for designing files and file groups in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is the difference between mysql and mysqli?
What is sql profiler. What are the default templates with it? : sql server database administration
Explain the microsoft sql server delete command?
What is the difference between SQL notification and SQL invalidation?
Is candidate a key?
