SQL DML90% of what you need to know:

SELECT <attributes>

FROM <tables>

WHERE <conditions>

• SELECT is a projection into the output

• FROM is effectively a Cartesian product of all the tables used

• WHERE are conditions, which could be very elaborate and even involve nested SELECTs.

Previous slide

Next slide

Back to first slide

View graphic version