Conventional set-theoretic operations and the SELECT statement

03:15

	Content	Login

SQL Problems and solutions S. I. Moiseenko

	SQL data manipulation language SELECT statement Conventional set-theoretic operations and the SELECT statement
	Conventional set-theoretic operations are union, intersection, exception, and Cartesian product. Suggested exercises: 73 Content: (5.7.1.) Cartesian product (5.7.2.) Union (5.7.3.) Intersect and Except (5.7.4) Sequence of fulfillment of UNION, EXCEPT, and INTERSECT operators (5.7.5.) EXISTS predicate Cartesian product UNION INTERSECT EXCEPT

Last added:

Tags

aggregate functions ALL ASCII AVG Battles Bezhaev Bismarck C.J.Date Cartesian product CASE cast CHAR CHARINDEX classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CTE data type conversion database schema DATEDIFF DATEPART DATETIME DELETE DISTINCT EXCEPT exercise (-2) exercise 19 exercise 23 exercise 37 exercise 39 exercise 46 exercise 54 exercise 55 exercise 56 exercise 57 exercise 7 exercise 70 exercise 8 exercises EXISTS FROM FULL JOIN GROUP BY grouping Guadalcanal More tags

The book was updated
yesterday

SQL Problems and solutions