1、使用比较运算符的子查询
=、>、<、>=、<=、<>、!=、<=>
语法结构:
operand comparision_operator subquery
eg: SELECT AVG(goods_prise) FROM tdb_goods;
2、用ANY、SOME、ALL修饰的比较运算符
operand comparision_operator ANY (subquery) //符合一个就行
operand comparision_operator SOME (subquery) //符合一个就行
operand comparision_operator ALL (subquery) //必须全部符合
eg: SELECT goods_id goods_name goods_prise FROM tdb_goods WHERE ANY (SELECT good_price FROM tdb_goods WHERE goods_cate='超极本')
=、>、<、>=、<=、<>、!=、<=>
语法结构:
operand comparision_operator subquery
eg: SELECT AVG(goods_prise) FROM tdb_goods;
2、用ANY、SOME、ALL修饰的比较运算符
operand comparision_operator ANY (subquery) //符合一个就行
operand comparision_operator SOME (subquery) //符合一个就行
operand comparision_operator ALL (subquery) //必须全部符合
eg: SELECT goods_id goods_name goods_prise FROM tdb_goods WHERE ANY (SELECT good_price FROM tdb_goods WHERE goods_cate='超极本')