Interested to Buy Any Domain ? << Click Here >> for more details...
What is UNION,UNION ALL?
- 2 Answers
- 13386 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 22 Yes | 9 No |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
what are the SQL codes u freequently got?
what needs to be done if a table is in copy pending / check pending status?
What is data manager?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
Can we use select * statement in cobol program without giving field names ???
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is a clustering index?
What are the bind parameters ibm db2?
What is bind in db2?
What is dbrm? What it contains?
COBOL 
