What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

What is difference between group by and partition by?

0 Answers  

---

How do you exit in sql?

0 Answers  

---

What are the different types of triggers?

0 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

What are sql*plus environment variables?

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

How to display the current date in sql?

0 Answers  

---