what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

What is dense_rank in 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  

---

what is hash join

1 Answers   NCR,

---

How does stored procedure reduce network traffic?

0 Answers  

---

---

Why do we use procedures?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

Which join is default?

0 Answers  

---

Why does sql need a server?

0 Answers  

---

How do you modify a table in sql?

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

Why do we use partitions in sql?

0 Answers  

---