What is difference between inner join and self join?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

What is trigger types of trigger?

0 Answers  

---

Explain lock escalation? : Transact sql

0 Answers  

---

What are different methods to trace the pl/sql code?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

What is example of database?

0 Answers  

---

how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

Why do we use function in pl 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  

---

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---