why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---

Can we join two tables without common column?

0 Answers  

---

What are the different types of a subquery?

0 Answers  

---

What is the purpose of a sql?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 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 ?

0 Answers  

---

How does index help in query performance?

0 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

What's the difference between a primary key and a clustered index?

0 Answers  

---