SQL----关联子查询

SELECT * FROM Table_2 AS S1
WHERE 售价>(SELECT AVG(售价) FROM Table_2 AS S2
            WHERE S1.商品=S2.商品 /*结合条件一定写在子查询中*/
             GROUP BY 商品)

SQL----关联子查询

标签：style   表格   div   span   sql   苹果   单位   order   必须