Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 47072 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / praveen k. agrawal
union is used For select distinct values from two tables
where as union all is used For select all values including
duplicates from the tables.
For Example Table X contain values(a,b,c) and Table Y
contain values(c,d,e)
In Case Of Union we will get Result-a,b,c,d,e
and other hand (Union All ) we will get-a,b,c,c,d,e.
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
Explain spool.
What is sql data?
What is plpgsql language?
Which type of cursor is used to execute the dml statement?
What does fetching a cursor do?
What is the order of sql select?
What is the difference between local and global temporary table?
What is the difference between between and in condition operators?
Write a unique difference between a function and a stored procedure.
How do I run a pl sql procedure in sql developer?
Which is better cte or subquery?
Is sql developer case sensitive?
What are synonyms in sql?
What is set serveroutput on in pl sql?
What is bitemporal narrowing?
