Database Administration Fundamentals (WS18SQL1001) – Day 5

We are half-way done with the course. We have covered how to retrieve data from table(s) and how to present that data in comprehensible manner.

SELECT [DISTINCT] table1.field1,
  table1.field2,
  ...
  table2.field1,
  table2.field2,
  ..
FROM table1
INNER|LEFT JOIN table2
  ON table1.sharedfile1 = table2.sharedfile1
    AND|OR table1.sharedfile2 = table2.sharedfile3
    ...
INNER|LEFT JOIN table3
  ON table1.sharedfile1 = table3.sharedfile1
    AND|OR table1.sharedfile2 = table3.sharedfile3
    ...
WHERE condition1
  AND|OR condition2
  ...
GROUP BY fields_not_in_aggregate_function
ORDER BY field1,
  field2
  ...;

Download the notes for day 5.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.