Answer Posted / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Can a commit statement be executed as part of a trigger?

998

---

what is 'mysqlshow'? : Sql dba

975

---

Can we join more than 2 tables in sql?

950

---

what is 'trigger' in sql? : Sql dba

1015

---

How do I view tables in mysql?

917

---

What is sql rowcount?

952

---

How do I get sql certification?

926

---

Is pl sql a programming language?

929

---

Can you load data into multiple tables at once? : aql loader

1024

---

What is delete command in sql?

1053

---

How many sql statements are used? Define them.

983

---

What are inner and outer joins examples of both?

881

---

Why do we use partitions in sql?

979

---

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 ?

955

---

Which is faster joins or subqueries?

931

---