Duplicate columns

Duplicate structures

Duplicate values

Duplicate rows

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed ORDER BY name) AS running_total_weight FROM cats

SELECT name, breed, SUM(weight) OVER (ORDER BY name) AS running_total_weight FROM cats

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed GROUP BY name) AS running_total_weight FROM cats ORDER BY name

SELECT name, breed, SUM(weight) OVER (PARTITION BY breed) AS running_total_weight FROM cats GROUP BY name

SELECT DISTINCT DepartmentNumber FROM Department HAVING DepartmentNumber

SELECT COUNT(*) FROM Department

SELECT COUNT(DISTINCT DepartmentNumber) FROM Department

A view can be permanently saved in the database with the table

All of the above

A view can include WHERE statements

A view can include joins between more than one table

SELECT FROM table_name1 AND table_name2

SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2

SELECT column_name(s) FROM table_name1 UNION table_name2

UNION SELECT column_name(s) FROM table_name1 SELECT column_name(s) FROM table_name2

-1

0

12

ERROR

It creates grouping combinations in a hierarchical way based on the input columns

It returns the same result set you would obtain by using the CUBE clause with and same input columns

It creates a SUM from the unique column combination used in the clause

It creates subtotals and grand totals from all possible column combinations

SELECT * FROM B UNION ALL SELECT * FROM C ORDER BY ID DESC

Both