What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

what is self-join? : Sql dba

0 Answers  

---

what is cross join? : Sql dba

0 Answers  

---

How can I tell if sql is running?

0 Answers  

---

How many sql databases can you have on one server?

0 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

what is sql optimization

1 Answers   Fidelity,

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---