Subquery

Again about subqueries

Using SOME(ANY) and ALL keywords with comparison predicates

INSERT statement

Data modification statements

Exercise #59

Database «Recycled materials company»

UPDATE statement

Data modification statements

Exercise #(-2)

Database «Ships»

Exercise #7

Computer Firm Database

Subqueries in Check Constraints

Data Definition Language (SQL DDL)

Exercise #17 (tips and solutions)

Tips and solutions

Relational division

SELECT statement

Using SOME(ANY) and ALL keywords with comparison predicates

SELECT statement

Exercise #13

Computer Firm Database

Exercise #24

Computer Firm Database