Retrieving Data

• SELECT col1, col2, ..., colN FROM table1, table2, ..., tableM [WHERE condition] [ORDER BY colx, coly, ...];

• SELECT name, title, dept FROM Employee WHERE dept='Accounting';