SQL UNION

Mar 6, 2013Download as PPTX, PDF0 likes2,228 views

The SQL UNION operator combines the results of two or more queries into a single result set. By default, UNION eliminates duplicate rows but UNION ALL includes duplicate rows. For UNION, the number and order of columns must match between queries and column data types must be compatible. Usually the column names from the first query are used. Examples demonstrate UNION, UNION ALL, and combining queries on the same table or with joins between tables.

SQL UNION

Reference :-

http://www.w3resource.com/sql/sql-union.php

http://dev.mysql.com/doc/refman/5.0/en/union.html

SQL UNION

Description:-

The SQL UNION operator combines the results of two or more queries and makes a
result set which includes fetched rows from the participating queries in the UNION.
Basic rules for combining two or more queries using UNION :
1.) number of columns and order of columns of all queries must be same.
2.) the data types of the columns on involving table in each query must be same or
compatible.
3.) Usually returned column names are taken from the first query.
By default the UNION behalves like UNION [DISTINCT] , i.e. eliminated the duplicate
rows; however, using ALL keyword with UNION returns all rows, including duplicates.

SQL UNION

Example of SQL UNION

Code:-

SELECT prod_code,prod_name

FROM product

UNION

SELECT prod_code,prod_name

FROM purchase;

SQL UNION ALL

Example of SQL UNION ALL

Code:-

SELECT prod_code,prod_name,com_name

FROM product

UNION ALL

SELECT prod_code,prod_name,com_name

FROM purchase;

SQL UNION ALL

Explanation

In the above example the optional clause ALL have been added with UNION for which,
all the rows from each query have been available in the result set. Here in the above
output the marking rows are non-unique but it has been displayed. If ignored ALL
clause, the marking rows would have come once.

Sql UNION ALL using where

Example of Sql UNION ALL using where

Code:-
SELECT prod_code,prod_name,com_name

FROM product

WHERE life>6

UNION ALL

SELECT prod_code,prod_name,com_name

FROM purchase

WHERE pur_qty>10

Sql UNION ALL using where

Explanation:-

In the above example the two queries have been set using two different criterias
including WHERE clause. So all the retrieve rows (including duplicates) have displayed
in the result set. Here in this example the marking rows are identical, but it has been
displayed for the ALL clause along with UNION. If ignored ALL clause the marking rows
would have come once.

Sql UNION a table to itself

Example of Sql UNION a table to itself

Code:-
SELECT prod_code,prod_name,com_name

FROM purchase

WHERE pur_qty>6

UNION ALL

SELECT prod_code,prod_name,com_name

FROM purchase

WHERE pur_amount>100000

Sql UNION a table to itself

Explanation:-

In the above example the two queries have been set using two different criterias for a
same table. So all the retrieved rows ( including duplicates ) have displayed. Here in
this example the marking rows are identical, but it has been displayed for the ALL
clause along with UNION.

Sql UNION with different column names

Example of Sql UNION a table to itself

Code:-
SELECT prod_code,prod_name,life

FROM product

WHERE life>6

UNION

SELECT prod_code,prod_name,pur_qty

FROM purchase

WHERE pur_qty<20

Sql UNION with different column names

Explanation:-

n the above example the two queries have been set using two different criterias and
different columns. The different columns in two statements are 'life' and 'pur_qty'. But
as the data type are same for both the columns so, result have displayed. Usually
returned column names are taken from the first query.

Sql UNION with Inner Join
Example of Sql UNION a table to itself
SELECT product.prod_code,product.prod_name,
Code:-
purchase.pur_qty, purchase.pur_amount

FROM product

INNER JOIN purchase

ON product.prod_code =purchase.prod_code

UNION

SELECT product.prod_code,product.prod_name,

purchase.pur_qty, purchase.pur_amount

FROM product

INNER JOIN purchase

ON product.prod_name =purchase.prod_name;

Sql UNION with Inner Join

Explanation:-

n the above example the union made by two queries. The queries are two inner join
statement. In the first query the join take place between two tables where the
prod_code of both tables are same and in the 2nd query the join take place between
two tables where the prod_name of both tables are same.

This document provides an overview of the key clauses in a SQL SELECT statement: 1. The SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses must be written in a specific order. The SELECT clause chooses the columns and FROM clause specifies the table. 2. The WHERE clause filters rows based on conditions and HAVING filters groups. GROUP BY divides rows into groups and ORDER BY sorts the results. 3. Examples demonstrate how each clause works, such as a SELECT statement that filters rows from a student table where the student ID equals 2.

Aggregate functionssinhacp

This document discusses aggregate functions in SQL. It defines aggregate functions as functions that summarize expression results over multiple rows into a single value. Commonly used aggregate functions include SUM, COUNT, AVG, MIN, and MAX. Examples are provided calculating sums, averages, minimums, and maximums of salaries in an employee table to illustrate the use of these functions. It also discusses issues like ignoring null values and the need to use the GROUP BY clause with aggregate functions.

SQL subqueryVikas Gupta

The document discusses subqueries in SQL. It defines a subquery as a SELECT statement embedded within another SELECT statement. Subqueries allow queries to be built from simpler statements by executing an inner query and using its results to inform the conditions of the outer query. The key aspects covered are: subqueries can be used in the WHERE, HAVING, FROM and other clauses; single-row subqueries use single-value operators while multiple-row subqueries use operators like ANY and ALL; and subqueries execute before the outer query to provide their results.

SQL Viewsbaabtra.com - No. 1 supplier of quality freshers

The document discusses various SQL concepts like views, triggers, functions, indexes, joins, and stored procedures. Views are virtual tables created by joining real tables, and can be updated, modified or dropped. Triggers automatically run code when data is inserted, updated or deleted from a table. Functions allow reusable code and improve clarity. Indexes allow faster data retrieval. Joins combine data from different tables. Stored procedures preserve data integrity.

introdution to SQL and SQL functionsfarwa waqar

This document provides an introduction to SQL (Structured Query Language). It defines SQL as a standard language for accessing and manipulating databases. The key points covered include: - SQL lets you perform queries against a database to retrieve, insert, update, and delete data. It can also be used to create and modify database structures. - Common SQL commands covered are SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, DROP TABLE. - Additional SQL concepts explained are data types, WHERE clauses, ORDER BY clauses, GROUP BY clauses, and JOIN operations. - RDBMS systems like MySQL, SQL Server, Oracle, etc. use SQL to communicate with the databases they manage.

Types Of Keys in DBMSPadamNepal1

This document discusses different types of keys used in databases. It defines keys as attributes that uniquely identify rows in tables. It then explains various key types including primary keys, candidate keys, super keys, alternate keys, unique keys, composite keys, foreign keys, natural keys and surrogate keys. For each key type, it provides examples from sample tables and discusses their properties and how they differ from each other. The document concludes that databases generally only contain primary, foreign, unique and surrogate keys, while other key types are conceptual, and that each table requires a unique key to reliably access and identify data.

SQL JOINRitwik Das

The document discusses different types of SQL joins, including inner joins, outer joins, equi joins, non-equi joins, natural joins, cross joins, left joins, right joins, full outer joins, and self joins. It provides the syntax and examples for each type of join. It also discusses joining tables through referential integrity, where a foreign key references a primary key in another table to link the tables together.

Sql joinsGaurav Dhanwant

SQL JOINS allow data to be combined from multiple tables by performing joins between columns that share common values. There are five main types of joins: equi joins which combine rows where joined columns are equal, inner joins which return rows where there is a match in both tables, outer joins which return all rows of the left or right table even if there is no match, self joins which join a table to itself, and non-equi joins which join on columns that are not equal. Joins are useful for combining related data across tables and are implemented using conditions in the WHERE clause that compare columns from different tables.

Computer Science:Sql Set OperationSt Mary's College,Thrissur,Kerala

The document discusses different SQL set operations - UNION, UNION ALL, INTERSECT, and MINUS. UNION combines results from two queries while eliminating duplicates. UNION ALL combines results and keeps duplicates. INTERSECT returns rows that are output from both queries. MINUS returns rows that are in the first query but not the second. Each set operation has specific rules regarding column names, data types, and order between the two queries being combined.

Nested Queries LectureFelipe Costa

This document provides an overview of nested queries in SQL, including examples and explanations of: - What nested queries are and how they are structured using subqueries - How to write nested queries using operators like IN, EXISTS, and correlated subqueries - Examples of nested queries for SELECT, UPDATE, DELETE, and the FROM clause using data on country fertility rates - Advantages of nested queries like readability and ability to isolate parts of statements

PL/SQL TRIGGERSLakshman Basnet

Triggers are stored programs that are automatically executed in response to events like data manipulation language (DML) statements or database definition language (DDL) statements. They can be used for purposes like enforcing referential integrity, auditing, and event logging. The syntax to create a trigger includes keywords like BEFORE, AFTER, INSTEAD OF to specify when it should be executed in relation to a triggering statement. PL/SQL packages are used to group related logic, types, variables and subprograms. A package has a specification that declares its elements and a body that defines them. Packages provide a way to encapsulate and organize code.

Structured Query Language (SQL)Syed Hassan Ali

Structured Query Language (SQL) is a standard language used to create, retrieve, and manage data in relational databases. SQL allows users to define tables, manipulate data within those tables through insert, update, delete statements, and retrieve data through select statements. SQL has different components including DDL for defining database structure, DML for manipulating data, DCL for controlling access, and TCL for managing transactions.

Sql joinVikas Gupta

This document discusses different types of joins in SQL, including inner joins, outer joins, cross joins, and natural joins. It provides guidelines for writing join conditions, handling ambiguous column names, and joining more than two tables. The key types of joins covered are equijoins for matching column values, outer joins to also return non-matching rows, and self joins to join a table to itself.

Joins And Its TypesWings Interactive

This document discusses different types of joins in SQL including inner joins, self joins, outer joins, and cross joins. An inner join combines rows from two tables based on a common column and returns matched rows. A self join performs an inner join on a single table to match rows with itself. Outer joins return all rows from one or both tables whether or not they have a match. A cross join returns the Cartesian product of all rows in two tables.

Sql joins inner join self join outer joinsDeepthi Rachumallu

This document discusses different types of SQL joins, including inner joins, left joins, right joins, full joins, and self joins. It provides examples of the syntax for each type of join, along with sample queries and resulting tables to illustrate how each join works. Inner joins return rows where there is a match in both tables. Left and right joins return all rows from the left or right table respectively, along with matched or null rows from the other table. Full joins return all rows and fill in nulls for missing matches. Self joins allow a table to join with itself.

Plsql lab mannualHarish Khodke

Group By, Having Clause and Order By clause Deepam Aggarwal

SQL Functionsammarbrohi

This document discusses different types of SQL functions including string, numeric, conversion, group, date/time, and user-defined functions. It provides examples of common string functions like UPPER, LENGTH, SUBSTR. Numeric functions covered include ABS, ROUND, POWER. Group functions include AVG, COUNT, MAX, MIN, SUM. Date functions allow conversion and calculation involving dates. The document demonstrates how to create scalar and table-valued user-defined functions in SQL.

Using the set operatorsSyed Zaid Irshad

This document discusses SQL set operators such as UNION, UNION ALL, INTERSECT, and MINUS. It provides examples of how to use each operator to combine result sets from multiple queries, eliminate duplicates, return common or unique rows, and control the order of rows in the final output. Tables used in the examples include the EMPLOYEES and JOB_HISTORY tables, which contain data on current and previous employee jobs. Guidelines are provided around matching columns in UNION queries and using parentheses and ORDER BY.

Sql Basics And Advancedrainynovember12

This document discusses revisiting SQL basics and advanced topics. It covers objectives, assumptions, and topics to be covered including staying clean with conventions, data types, revisiting basics, joining, subqueries, joins versus subqueries, group by, set operations, and case statements. The topics sections provides details on each topic with examples to enhance SQL knowledge and write better queries.

SQL Join BasicNaimul Arif

The document discusses different types of SQL join operations including inner, left, right, and outer joins. It provides examples of each join type using sample tables and explains how the results of each join are determined. Key points covered include how joins combine rows from two or more tables based on matching column values, and how different join types handle rows with no matches differently, such as including or excluding them from results.

SQLShyam Khant

Set operatorsManuel S. Enverga University Foundation

Oracle SQL BasicsDhananjay Goel

This document provides an overview and introduction to Oracle SQL basics. It covers topics such as installing Oracle software like the database, Java SDK, and SQL Developer tool. It then discusses database concepts like what a database and table are. It also covers database fundamentals including SQL queries, functions, joins, constraints, views and other database objects. The document provides examples and explanations of SQL statements and database components.

DML CommandsRandy Riness @ South Puget Sound Community College

Constraints In SqlAnurag

The document discusses various types of constraints in SQL including column level constraints like NOT NULL, UNIQUE, DEFAULT, and CHECK constraints as well as table level constraints like PRIMARY KEY and FOREIGN KEY. It provides examples of how to define these constraints when creating or altering tables and explains how each constraint enforces integrity rules and data validation. Constraints are used to impose rules on data values and relationships between columns and tables.

Create tableNitesh Singh

The document discusses the concept of tables in databases and how to create tables in SQL. It defines what a table is, explains that tables can represent entities, relationships between entities, or lists. It then covers the syntax and rules for creating tables, including specifying the table name, columns, data types, constraints like primary keys, unique keys, foreign keys, default values and check constraints. Examples are provided for creating tables with different constraints. The roles of constraints in enforcing data integrity are also discussed.

Chapter 4 Structured Query LanguageEddyzulham Mahluzydde

Sql ch 5Mukesh Tekwani

The document discusses various SQL query concepts including: 1. Search conditions (predicates) in SQL queries including comparison tests, range tests, set membership tests, pattern matching tests, and null value tests. 2. The UNION feature allows combining the results of two or more queries into a single table. Query results combined with UNION can be sorted using an ORDER BY clause. 3. JOIN operations combine data from two or more tables by linking a column in one table with that in another table. Inner joins and outer joins are explained with examples.

Sql clauses by Manan PasrichaMananPasricha

More Related Content

What's hot (20)

Computer Science:Sql Set OperationSt Mary's College,Thrissur,Kerala

Nested Queries LectureFelipe Costa

PL/SQL TRIGGERSLakshman Basnet

Structured Query Language (SQL)Syed Hassan Ali

Sql joinVikas Gupta

Joins And Its TypesWings Interactive

Sql joins inner join self join outer joinsDeepthi Rachumallu

Plsql lab mannualHarish Khodke

Group By, Having Clause and Order By clause Deepam Aggarwal

SQL Functionsammarbrohi

Using the set operatorsSyed Zaid Irshad

Sql Basics And Advancedrainynovember12

SQL Join BasicNaimul Arif

SQLShyam Khant

Set operatorsManuel S. Enverga University Foundation

Oracle SQL BasicsDhananjay Goel

DML CommandsRandy Riness @ South Puget Sound Community College

Constraints In SqlAnurag

Create tableNitesh Singh

Chapter 4 Structured Query LanguageEddyzulham Mahluzydde

Computer Science:Sql Set OperationSt Mary's College,Thrissur,Kerala

Nested Queries LectureFelipe Costa

PL/SQL TRIGGERSLakshman Basnet

Structured Query Language (SQL)Syed Hassan Ali

Sql joinVikas Gupta

Joins And Its TypesWings Interactive

Sql joins inner join self join outer joinsDeepthi Rachumallu

Plsql lab mannualHarish Khodke

Group By, Having Clause and Order By clause Deepam Aggarwal

SQL Functionsammarbrohi

Using the set operatorsSyed Zaid Irshad

Sql Basics And Advancedrainynovember12

SQL Join BasicNaimul Arif

SQLShyam Khant

Set operatorsManuel S. Enverga University Foundation

Oracle SQL BasicsDhananjay Goel

DML CommandsRandy Riness @ South Puget Sound Community College

Constraints In SqlAnurag

Create tableNitesh Singh

Chapter 4 Structured Query LanguageEddyzulham Mahluzydde

Similar to SQL UNION (20)

Sql ch 5Mukesh Tekwani

Sql clauses by Manan PasrichaMananPasricha

Sql TuningMuhammadAbdulRehmanQ

The document provides guidelines for optimizing SQL queries for better performance. It discusses techniques like using WHERE clauses to filter rows instead of retrieving all rows; using joins instead of multiple queries when joining tables; fully qualifying column references in joins; using CASE expressions instead of multiple queries for calculations; using WHERE instead of HAVING to filter rows; using UNION ALL instead of UNION to avoid removing duplicate rows; using EXISTS instead of IN or DISTINCT for subqueries. The document contains examples of inefficient queries and improved queries using the recommended techniques.

Sql wksht-6Mukesh Tekwani

The document discusses SQL JOIN statements. It defines an INNER JOIN as returning rows when there is at least one match between two tables. It provides an example of using INNER JOIN to combine data from Customers and Orders tables based on matching CustomerNumber columns. It also provides a simple example using INNER JOIN to extract customer names and total sales amounts from Customers and Sales tables by matching on CustomerID.

Chapter9 more on database and sqlKV(AFS) Utarlai, Barmer (Rajasthan)

This document discusses various SQL functions and concepts including: 1. Single row and multiple row/aggregate functions where single row functions return one result per row and aggregate functions return one result for a group of rows. Common aggregate functions discussed are AVG, COUNT, MAX, MIN, and SUM. 2. The GROUP BY clause which combines records with the same field values and the HAVING clause which specifies conditions for grouped data. 3. Joins which combine data from multiple tables. Types discussed are Cartesian products and equi-joins. 4. SQL constraints including NOT NULL, DEFAULT, UNIQUE, and PRIMARY KEY constraints.

SqlAman Lalpuria

This document provides an overview of SQL commands and examples, including SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, JOIN, UNION and more. Key points include: - SQL is a standard language for accessing and manipulating databases and became an ANSI and ISO standard in the 1980s. - Common SQL commands allow users to query data with SELECT, insert/update/delete records, and perform other data management tasks. - Logical operators like WHERE, AND, OR, NOT allow for filtering query results. - JOINs combine data from multiple tables by common columns. - Aggregate functions like COUNT, SUM, AVG perform calculations across record sets. - Examples

Sql joinsVivek Singh

SQL joins relate information between tables by matching common columns. There are two main types of joins - equi joins which use equality comparisons and non-equi joins which use other comparisons like greater than. Equi joins include inner joins which only return rows matching the join condition and outer joins which return all rows including those with no matches. Non-equi joins use comparisons other than equality to join rows between tables. Self joins match a table to itself using a foreign key that references its own primary key.

Unit 3-Select Options and Aggregate Functions in SQL (1).pptxHAMEEDHUSSAINBU21CSE

Select statement is used to fetch data from one or more tables. It can use predicates like WHERE, GROUP BY, HAVING, and ORDER BY. The WHERE clause filters rows based on conditions, GROUP BY organizes rows into groups, HAVING applies conditions to groups, and ORDER BY sorts the results. Aggregate functions like COUNT, SUM, AVG, MAX, MIN perform calculations on multiple rows and return a single value.

Database Architecture and Basic ConceptsTony Wong

The document provides an overview of database architecture and basic concepts such as what a database is, structured query language (SQL), and stored procedures. A database allows for structured storage and retrieval of complex data. SQL is used to manipulate and retrieve data from databases. Stored procedures are programs stored in databases that perform specific tasks like validating arguments. They provide benefits like improved performance and protection of database integrity.

Unit 3-p2relationaldatabasescodeing.pptxartipunia12

Les07[1]Multiple-Column Subqueriessiavosh kaviani

advanced sql(database)welcometofacebook

This document discusses advanced SQL topics including joins, subqueries, and ensuring transaction integrity. It provides examples of different types of joins like equi-joins, natural joins, outer joins, and union joins. It also discusses using subqueries in WHERE clauses, FROM clauses, and HAVING clauses, and differentiates between correlated and noncorrelated subqueries. The document concludes by defining transactions and describing SQL commands like BEGIN TRANSACTION, COMMIT, and ROLLBACK that are used to ensure transaction integrity.

OER UNIT 5 SQL MODEL CLAUSEGirija Muscut

The document discusses the SQL model clause in Oracle for data warehousing. It describes how the model clause builds multidimensional arrays (models) using dimensions, measures, and partitions from a source table. Dimensions define the rows and columns in the model, measures contain values that can be modified in rules, and partitions divide the result set. Rules are used to assign new values to measures. The document provides examples of using different components of the model clause, including dimensions, measures, partitions, rules, and looping and iteration.

1 z0 047Md. Shamsul haque

Oracle: JoinsDataminingTools Inc

Oracle: Joinsoracle content

The Database Environment Chapter 8Jeanie Arnoco

This document summarizes advanced SQL concepts including joins, subqueries, transactions, and other features. It discusses join types like equi-joins and outer joins. It describes how to use subqueries in the WHERE, FROM, and HAVING clauses. It also covers ensuring transaction integrity with commands like BEGIN TRANSACTION, COMMIT, and ROLLBACK. The document provides examples of joins, subqueries, and transactions.

235689260 oracle-forms-10g-tutorialhomeworkping3

5. Group FunctionsEvelyn Oluchukwu

This document discusses group functions in SQL, which operate on groups of rows and return results. It covers common group functions like COUNT, AVG, SUM, MIN, MAX, STDDEV and VARIANCE. It explains how to use the GROUP BY clause to group data by columns and the HAVING clause to include or exclude grouped rows. Examples are provided for counting rows, getting averages, and filtering groups. Nested groups and the order of operations are also discussed.

ADV PPT 8 LAB.pptxArjayBalberan1

The MySQL GROUP BY statement groups rows that have the same values into summary rows. It is often used with aggregate functions like COUNT(), MAX(), MIN(), SUM(), AVG() to group the result set by one or more columns. The GROUP BY statement syntax includes SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses. Examples show using GROUP BY to find the number of customers in each country and the number of orders sent by each shipper.

Sql ch 5Mukesh Tekwani

Sql clauses by Manan PasrichaMananPasricha

Sql TuningMuhammadAbdulRehmanQ

Sql wksht-6Mukesh Tekwani

Chapter9 more on database and sqlKV(AFS) Utarlai, Barmer (Rajasthan)

SqlAman Lalpuria

Sql joinsVivek Singh

Unit 3-Select Options and Aggregate Functions in SQL (1).pptxHAMEEDHUSSAINBU21CSE

Database Architecture and Basic ConceptsTony Wong

Unit 3-p2relationaldatabasescodeing.pptxartipunia12

Les07[1]Multiple-Column Subqueriessiavosh kaviani

advanced sql(database)welcometofacebook

OER UNIT 5 SQL MODEL CLAUSEGirija Muscut

1 z0 047Md. Shamsul haque

Oracle: JoinsDataminingTools Inc

Oracle: Joinsoracle content

The Database Environment Chapter 8Jeanie Arnoco

235689260 oracle-forms-10g-tutorialhomeworkping3

5. Group FunctionsEvelyn Oluchukwu

ADV PPT 8 LAB.pptxArjayBalberan1

Recently uploaded (20)

Cisco Duo 2024 Cisco Duo 2024 Cisco Duo 2024MichaelLee15927

UiPath Automation Developer Associate Training Series 2025 - Session 4DianaGray10

Please join us for session 4 of the Developer Associate series, where we will cover selectors in Studio and PDF Automation in Studio. Topics covered: Selectors in Studio PDF Automation with Studio Required self-paced training to be completed for this session: Selectors in Studio Deep Dive - 2 modules - 1h 30m - https://academy.uipath.com/courses/selectors-in-studio-deep-dive PDF Automation with Studio - 2 modules - 1h 15m - https:/academy.uipath.com/courses/pdf-automation-in-studio ?? For any questions you may have, please use the dedicated Forum thread. You can tag the hosts and mentors directly and they will reply as soon as possible.

Unlock AI Creativity: Image Generation with DALL��EExpeed Software

Discover the power of AI image generation with DALL��E, an advanced AI model that transforms text prompts into stunning, high-quality visuals. This presentation explores how artificial intelligence is revolutionizing digital creativity, from graphic design to content creation and marketing. Learn about the technology behind DALL��E, its real-world applications, and how businesses can leverage AI-generated art for innovation. Whether you're a designer, developer, or marketer, this guide will help you unlock new creative possibilities with AI-driven image synthesis.

Automated Minutes - Redefining Capturing & Creating MinutesOnBoard

Using speech recognition and natural language processing, Automated Minutes creates an accurately transcribed meeting minutes draft in a near real-time, secure environment. On March 11th at 2 PM EST OnBoard��s product team, Heather Hansson and Philip Hinz, explored the power of OnBoard��s Automated Minutes. Using this webinar, you can learn: Why Automated Minutes? Customizable, Secure, and Governance-Built for Boards How Automated Minutes works to capture and create an initial draft of your minutes Personalizing and formatting your Minutes through rich text editing tools

Read- and Write-Optimization in Modern Database Infrastructures by Dzejla Med...ScyllaDB

Gmetrics: Processing Metrics at Uber Scale by Cristian VelazquezScyllaDB

People, Process, Technology, Business...annashipman

SMART SENTRY CYBER THREAT INTELLIGENCE IN IIOTTanmaiArni

Verbose AI: The Accessibility Challenge - CSUN 2025Ted Drake

DAO UTokyo 2025 DLT mass adoption case studies IBM Tsuyoshi Hirayama (ƽɽ��)Tsuyoshi Hirayama

ScyllaDB is No Longer "Just a Faster Cassandra" by Felipe Cardeneti MendesScyllaDB

Predictable performance isn't just a feature��it's a must for anyone building serious, data-intensive applications at scale. ScyllaDB has often been labeled merely as a faster alternative to Cassandra, but is that all there is to it? In this talk, let's discuss the results of our head-to-head comparison between the long-delayed Apache Cassandra 5.0 release versus ScyllaDB and explain what truly sets ScyllaDB apart beyond just speed.

Who Needs One Database Anyway? byGlauber CostaScyllaDB

Extreme Elasticity with Tablets, Raft and Kubernetes by Maciej ZimnochScyllaDB

The Mechanics of Scale by Dominik TornowScyllaDB

Raport-trendy-technologia-FTSG_2025_TR_FINAL_LINKEDagatadrynko

How Agoda Scaled 50x Throughput with ScyllaDB by Worakarn IsarathamScyllaDB

ScyllaDB: 10 Years and Beyond by Dor LaorScyllaDB

There��s a common adage that it takes 10 years to develop a file system. As ScyllaDB reaches that 10 year milestone in 2025, it��s the perfect time to reflect on the last decade of ScyllaDB development �C both hits and misses. It��s especially appropriate given that our project just reached a critical mass with certain scalability and elasticity goals that we dreamed up years ago. This talk will cover how we arrived at ScyllaDB X Cloud achieving our initial vision, and share where we��re heading next.

Bridging the Gap from Telco to Techco with Agile ArchitectureBATbern

The Telco industry is undergoing a major IT transformation, shifting from Telco to Techco. This shift is driven by a breakneck pace of technological change that traditional architectures simply cannot keep up with. In my presentation, I will explore the profound impact of digitization on Telco architecture. Using examples from Swisscom's Network Division, I will show why Agile Architecture is crucial for cutting complexity, accelerating time-to-market, and sparking innovation within the organization. This approach isn't just strategic; it's vital for the future success of our industry. Join me to uncover how Swisscom is navigating this transformation and what lessons can be applied to your organization.

TrustArc Webinar: How to Create a Privacy-First CultureTrustArc

Privacy is no longer just a compliance issue��it��s a cornerstone of trust and a vital element of business success. Yet, many organizations struggle to embed privacy into their culture, leaving them vulnerable to breaches, regulatory action, and damaged reputations. Are your employees equipped to make privacy-conscious decisions? Does your company have the tools and mindset to prioritize data protection at every level? This webinar brings together a panel of experts to explore why a strong privacy culture is critical and how it can drive both organizational integrity and customer confidence. You��ll learn how to align privacy values with business objectives, foster awareness and accountability among employees, and create policies that empower teams to safeguard sensitive information effectively. Through engaging discussions and practical insights, we��ll provide actionable strategies for implementing privacy programs that stick. From building leadership support to weaving privacy considerations into daily workflows, you��ll discover what it takes to turn compliance into a competitive advantage and a core part of your company��s identity. This webinar will review: - Why your company needs a privacy culture - Best practices for building a privacy-first culture - Practical tips for implementing effective privacy programs

CFD Studio Credentials �C Branding, Design & Developmenttrannghia2018

Cisco Duo 2024 Cisco Duo 2024 Cisco Duo 2024MichaelLee15927

UiPath Automation Developer Associate Training Series 2025 - Session 4DianaGray10

Unlock AI Creativity: Image Generation with DALL��EExpeed Software

Automated Minutes - Redefining Capturing & Creating MinutesOnBoard

Read- and Write-Optimization in Modern Database Infrastructures by Dzejla Med...ScyllaDB

Gmetrics: Processing Metrics at Uber Scale by Cristian VelazquezScyllaDB

People, Process, Technology, Business...annashipman

SMART SENTRY CYBER THREAT INTELLIGENCE IN IIOTTanmaiArni

Verbose AI: The Accessibility Challenge - CSUN 2025Ted Drake

DAO UTokyo 2025 DLT mass adoption case studies IBM Tsuyoshi Hirayama (ƽɽ��)Tsuyoshi Hirayama

ScyllaDB is No Longer "Just a Faster Cassandra" by Felipe Cardeneti MendesScyllaDB

Who Needs One Database Anyway? byGlauber CostaScyllaDB

Extreme Elasticity with Tablets, Raft and Kubernetes by Maciej ZimnochScyllaDB

The Mechanics of Scale by Dominik TornowScyllaDB

Raport-trendy-technologia-FTSG_2025_TR_FINAL_LINKEDagatadrynko

How Agoda Scaled 50x Throughput with ScyllaDB by Worakarn IsarathamScyllaDB

ScyllaDB: 10 Years and Beyond by Dor LaorScyllaDB

Bridging the Gap from Telco to Techco with Agile ArchitectureBATbern

TrustArc Webinar: How to Create a Privacy-First CultureTrustArc

CFD Studio Credentials �C Branding, Design & Developmenttrannghia2018

SQL UNION

1. SQL UNION Reference :- http://www.w3resource.com/sql/sql-union.php http://dev.mysql.com/doc/refman/5.0/en/union.html

2. SQL UNION Description:- The SQL UNION operator combines the results of two or more queries and makes a result set which includes fetched rows from the participating queries in the UNION. Basic rules for combining two or more queries using UNION : 1.) number of columns and order of columns of all queries must be same. 2.) the data types of the columns on involving table in each query must be same or compatible. 3.) Usually returned column names are taken from the first query. By default the UNION behalves like UNION [DISTINCT] , i.e. eliminated the duplicate rows; however, using ALL keyword with UNION returns all rows, including duplicates.

3. SQL UNION Example of SQL UNION Code:- SELECT prod_code,prod_name FROM product UNION SELECT prod_code,prod_name FROM purchase;

4. SQL UNION ALL Example of SQL UNION ALL Code:- SELECT prod_code,prod_name,com_name FROM product UNION ALL SELECT prod_code,prod_name,com_name FROM purchase;

5. SQL UNION ALL Explanation In the above example the optional clause ALL have been added with UNION for which, all the rows from each query have been available in the result set. Here in the above output the marking rows are non-unique but it has been displayed. If ignored ALL clause, the marking rows would have come once.

6. Sql UNION ALL using where Example of Sql UNION ALL using where Code:- SELECT prod_code,prod_name,com_name FROM product WHERE life>6 UNION ALL SELECT prod_code,prod_name,com_name FROM purchase WHERE pur_qty>10

7. Sql UNION ALL using where Explanation:- In the above example the two queries have been set using two different criterias including WHERE clause. So all the retrieve rows (including duplicates) have displayed in the result set. Here in this example the marking rows are identical, but it has been displayed for the ALL clause along with UNION. If ignored ALL clause the marking rows would have come once.

8. Sql UNION a table to itself Example of Sql UNION a table to itself Code:- SELECT prod_code,prod_name,com_name FROM purchase WHERE pur_qty>6 UNION ALL SELECT prod_code,prod_name,com_name FROM purchase WHERE pur_amount>100000

9. Sql UNION a table to itself Explanation:- In the above example the two queries have been set using two different criterias for a same table. So all the retrieved rows ( including duplicates ) have displayed. Here in this example the marking rows are identical, but it has been displayed for the ALL clause along with UNION.

10. Sql UNION with different column names Example of Sql UNION a table to itself Code:- SELECT prod_code,prod_name,life FROM product WHERE life>6 UNION SELECT prod_code,prod_name,pur_qty FROM purchase WHERE pur_qty<20

11. Sql UNION with different column names Explanation:- n the above example the two queries have been set using two different criterias and different columns. The different columns in two statements are 'life' and 'pur_qty'. But as the data type are same for both the columns so, result have displayed. Usually returned column names are taken from the first query.

12. Sql UNION with Inner Join Example of Sql UNION a table to itself SELECT product.prod_code,product.prod_name, Code:- purchase.pur_qty, purchase.pur_amount FROM product INNER JOIN purchase ON product.prod_code =purchase.prod_code UNION SELECT product.prod_code,product.prod_name, purchase.pur_qty, purchase.pur_amount FROM product INNER JOIN purchase ON product.prod_name =purchase.prod_name;

13. Sql UNION with Inner Join Explanation:- n the above example the union made by two queries. The queries are two inner join statement. In the first query the join take place between two tables where the prod_code of both tables are same and in the 2nd query the join take place between two tables where the prod_name of both tables are same.

�ݺ�ߣ

SQL UNION

Recommended

More Related Content

What's hot (20)

Similar to SQL UNION (20)

Recently uploaded (20)

SQL UNION