How do you concatenate in sql?

0 Answers  

---

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  

---

What is pl sql and why it is used for?

0 Answers  

---

What are the benefits of pl sql?

0 Answers  

---

What is left inner join in sql?

0 Answers  

---

---

what is schema? : Sql dba

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

Which is better join or subquery?

0 Answers  

---

What is sql deadlock?

0 Answers  

---