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,

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

Why do we use procedures in pl sql?

0 Answers  

---

What is a native sql query?

0 Answers  

---

What is query syntax?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

What is view? Can we update view

0 Answers  

---

Can cursors be part of a trigger body?

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---