Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepak kumar
SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 ?
Is natural join same as inner join?
Write a unique difference between a function and a stored procedure.
what is the difference between myisam static and myisam dynamic? : Sql dba
Explain the rollback statement?
What is difference between mysql and postgresql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is the difference between sql and mysql?
what are the advantages of mysql in comparison to oracle? : Sql dba
How many joins can you have in sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is left join example?
What are the most important ddl statements in sql?
What is a full join?
Explain the working of foreign key?
