Where not exists in sql?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

Describe types of sql statements?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

How many aggregate functions are available there in sql?

0 Answers  

---

---

what is a constraint? : Sql dba

0 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

Why is normalization important?

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

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 are sql objects?

0 Answers  

---