Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 47053 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / vibha kant pandey
Hi friends check it this may help you all.
UNION
The UNION command is used to select related information from
two tables, much like the JOIN command. However, when using
the UNION command all selected columns need to be of the
same data type. With UNION, only distinct values are selected.
UNION ALL
The UNION ALL command is equal to the UNION command, except
that UNION ALL selects all values.
The difference between Union and Union all is that Union all
will not eliminate duplicate rows, instead it just pulls all
rows from all tables fitting your query specifics and
combines them into a table.
A UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.
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 ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Sql technical questions
what are date and time functions in mysql? : Sql dba
Is mariadb a nosql database?
how to use 'mysql' to run sql statements? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are the set operators in sql?
What is equi join in sql?
What is a ddl command?
What does (+) mean in sql joins?
is it possible to pass an object or table to a procedure as an argument?
Explain foreign key in sql?
How can a function retun more than one value in oracle with proper example?
What are the uses of sysdate and user keywords?
Explain the order of sql statement execution?
