Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373222 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / jhansi
select max(sal) from emp where sal<any(select max(sal) from
emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are few of the schema objects that are created using PL/SQL?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is synchronized subquery?
The select into statement is most often used to create backup copies of tables or for archiving records?
Who developed sql?
What is difference between procedure and trigger?
what is the difference between clustered and non clustered index in sql? : Sql dba
Can we use threading in pl/sql?
What is a Mapplet?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is difference between primary and secondary key?
Is not equal in sql?
What is meaning of <> in sql?
What is difference between inner join and self join?
