SQL For Everyone - Tutorial 32 - Combining Queries

preview_player
Показать описание


SQL For Everyone - Tutorial 32 - Combining Queries

The UNION operator is used to combine the result-set of two or more SELECT statements.

Each SELECT statement within UNION must have the same number of columns
The columns must also have similar data types
The columns in each SELECT statement must also be in the same order

#sql #union #algometica

Рекомендации по теме
Комментарии
Автор

Question, let’s say you Union the same query (that all have the same select) but you want to label one query as a specific name and same with the other to distinguish it. How would you do that?

ishmaelgamer
Автор

It's very important that you must hit the enter key with full force otherwise it may not work for you

cs-ykqh