1/28/16
Ø
Union
Ø
Union all
Ø
Intersect
Ø
Minus
UNION
This will combine the records of multiple tables having
the same structure.
Ex:
UNION ALL
This will combine the records of
multiple tables having the same structure but including duplicates.
Ex:
SQL> select * from
student1 union all select * from student2;
INTERSECT
This will give the common records of multiple tables
having the same structure.
Ex:
SQL> select * from
student1 intersect select * from student2;
MINUS
This will give the records of a
table whose records are not in other tables having the same structure.
Ex:
SQL> select * from
student1 minus select * from student2;
Free Video Tutorials(YouTube)
Manual Testing Full Course for Beginners
Java Full Course for Beginners
Python Full Course for Beginners
JMeter Full Course for Beginners
Big Data Testing Full course for Beginners
Agile + Jira Tool Full Course for Beginners
Appium (Android & ios) Full Course for Beginners
Linux & Shell Scripting for Beginners
Big Data/Hadoop Testing Videos for Beginners
ContinuousIntegration with Maven, Git & Github
Selenium withPython Robot Framework for Beginners
Appium(MobileApp Testing) for Beginners
TestNG Tutorials with IntelliJ IDE
Selenium with Java+Cucumber BDD Framework Development
Cucumber for Beginners
API Automation Testing using RestAssured(BDD Approach)
Channel Link: https://goo.gl/2XKXRB

0 comments:
Post a Comment