MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

MySQL

Union In MySQL
Previous Home Next

It allow us to add one or more column from one or more table in a single output. It follow some conditions to perform they are:

  1. Number of column should be equal in both sides.
  2. Both the matched column should have some type of data.

Syntax for Union

SELECT columnname1, columnname2
FROM table1
UNION DISTINCT | ALL
SELECT columnname1, columnname2
FROM table2
[WHERE CLAUSE
ORDER BY CLAUSE]

Example

SELECT ocuptn, sex
FROM studptin
UNION
SELECT fname,age
FROM studinfo ;

 

Default value use in union is distinct.

Example

SELECT fname,age
FROM studinfo
UNION ALL
SELECT ocuptn, sex
FROM studptin ;

The full output can be shown by all in union condition.

Example

SELECT ocuptn, sex
FROM studptin
UNION 
SELECT fname,age
FROM studinfo 
WHERE age>23
ORDER BY ocuptn;

Include the where and order b y condition in the above code.

Example

( SELECT ocuptn, sex
FROM studptin )
UNION 
( SELECT fname,age
FROM studinfo )
ORDER BY 2,1;

The type of order define in terms of the second select column name define in the code.

Previous Home Next