What is a stored procedure in sql with example?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

Why partition by is used in sql?

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

What is varchar example?

0 Answers  

---

Is and as keyword in pl sql?

0 Answers  

---

What are Anti joins

1 Answers   IBM,

---

how to retrieve only duplicate values in a table

9 Answers  

---

Are sql database names case sensitive?

0 Answers  

---

What is ON DELETE CASCADE?

3 Answers  

---

What is pragma in sql?

0 Answers  

---

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

---