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,

---

display your age in months?

2 Answers  

---

What are inner and outer joins examples of both?

0 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---

How to pronounce postgresql?

0 Answers  

---

What are different sql data types?

0 Answers  

---

Can we update views in sql?

0 Answers  

---

What is the sql query to display the current date?

0 Answers  

---

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

What is set transaction?

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---