Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7431 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ritesh
select max(salary) from emptable where salary < (select max(salary) from emptable);
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vijayalakshmi
select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name
| Is This Answer Correct ? | 4 Yes | 0 No |
select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santosh kumar
select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a user and a schema in oracle?
What is an Index Segment ?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
what is the use of system.effective.date variable in oracle?
What the is the diff between local index and global index. give some example.
Respected sir, Please send me technical questions related to oracle apps..
What is a Sequence ?
what is index?
How will you differentiate between varchar & varchar2?
Explain constraining triggers.
when do u go for hash partitioning?
Explain the use of owner option in exp command.
Oracle General 
