Data Manipulation(1)

• Select

• from,order by,as,distinct
• where: IN NOT IN
• group by, having
• aggregate functions:Count sum avg min max
• subquery:any/some, all
• outer join pp.141-143
• Exists

• Insert into, Insert into select

• select into