1. 5 SELECT A.*,
    2. 列名,
    3. 表达式
    4. 1 FROM A
    5. 2 WHERE A.ENAME = 'UZI'
    6. 3 GROUP BY A.NUM
    7. 4 HAVING A.SAL > 2200
    8. 6 ORDER BY A.HIREDATE [ASC/DESC]