how can we find nth max salary from A table
- 5 Answers
- 23653 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / asp
select * from table1 a where (n-1) = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)
| Is This Answer Correct ? | 15 Yes | 5 No |
Answer / bhaskar reddy
select * from table1 a where(n-1)= (select count(distinct
sal) from table1 b where b.sal>a.sal)
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / sivaraman
select * from table1 a where n = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)
n is value of n it should be numeric....
| Is This Answer Correct ? | 15 Yes | 15 No |
Answer / a
select MAX(Salary) from Employee
WHERE Salary NOT IN (select MAX(Salary) from Employee )
| Is This Answer Correct ? | 0 Yes | 9 No |
What is cursor stability?
why we create view.
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
Define check constraint.
What are concurrency issues?
What is a thread?
Define data page.
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is QUIESCE?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is a base table?
pls explain the precompilation process of cobol-db2 pgm
COBOL 
