查询价格大于或等于"超级本"价格的商品，并且按价格降序排列----但是这个语句好像仅仅只是查询>=价格的"超极本"
SELECT goods_id,goods_name,goods_price
FROM tdb_goods
WHERE goods_price = ANY(SELECT goods_price FROM tdb_goods WHERE goods_cate = '超级本')ORDER BY goods_price DESC;
2 回答
举报
0/150
提交
取消
SELECT goods_id,goods_name,goods_price
FROM tdb_goods
WHERE goods_price = ANY(SELECT goods_price FROM tdb_goods WHERE goods_cate = '超级本')ORDER BY goods_price DESC;
2016-02-26
举报
