What is the difference between the implicit and explicit cursors?

0 Answers  

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

What is function and procedure in pl sql?

0 Answers  

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---

---

How do we use distinct statement? What is its use?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

What is partition in sql query?

0 Answers  

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

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  

---

Is sql pronounced sequel or sql?

0 Answers  

---

what are the limitations of identity column? : Transact sql

0 Answers  

---