What is a loop in sql?

0 Answers  

---

What is embedded sql with example?

0 Answers  

---

Which sql most popular?

0 Answers  

---

How do I create an index in word?

0 Answers  

---

Which is better cte or subquery?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

What is materialized view in sql?

0 Answers  

---

Define sql delete statement.

0 Answers  

---

What are aggregate functions in sql?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

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  

---