can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34153 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / elumalai.k
select max(salary)from tablename where salary <(select
max(salary)from tablename)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to rebuild the master database?
Why should you use or avoid select * statements?
Why and when do stored procedure recompile?
What is the primary use of the model database?
What are wait types?
How efficient you are in oracle and SQL server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can one drop a column from a table?
How raid can influence database performance?
What is acid mean in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Equi join and non equi join is possible with sql server?
What is the difference between upgrade and migration in sql server?
