Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7497 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 |
Why do we use bulk collect in oracle?
How to connect to the server with user account: sys?
Explain view?
What is an Index ?
How to define a variable to match a table column data type?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain temporal data types in oracle
How many types of tables supported by oracle?
How to experiment a data lock in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain the use of grant option in imp command.
Explain enable novalidate constraint.
Oracle General 
