Answer / sanjudharan

UNION : eliminates duplicates

UNION ALL: retains duplicates

Both these are used to combine the results of different
SELECT statements.

Suppose I have five SQL SELECT statements connected by
UNION/UNION ALL, how many times should I specify UNION to
eliminate the duplicate rows? -

Once.

Answer / sandeep

Correct answer..

i want to delete 20th million record how ?

4 Answers   IBM,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

What is sqlcode -922 ?

2 Answers  

---

What is correlated subquery?

1 Answers  

---

Update command

1 Answers  

---