SQL Examples

SELECT DISTINCT city

FROM customers

WHERE city IS NOT NULL;

SELECT [Part No], Sum(quantity*[Unit Price]) AS Total

FROM Orders

GROUP BY [Part No];

Previous slide

Next slide

Back to first slide

View graphic version