sql 标量子查询

返回结果只有一行的查询叫标量子查询.

SELECT shohin_mei shohin_bunrui FROM Shohin WHERE hanbai_tanka > (SELECT AVG(hanbai_tanka) FROM Shohin);

标量子查询可以和列一样

mysql> SELECT shohin_id ,shohin_mei,shohin_bunrui,\

    -> (SELECT AVG(hanbai_tanka) FROM Shohin) AS avg_tanka\

    -> FROM Shohin;