SELECT code
FROM stock
GROUP BY code
HAVING COUNT(*) >= 4 AND MIN(huanshoulv) >=10 and min(danqianjia) >=0 and sum(zhandifu) <10
分组查询,最小值 于必须大于。总和必须大于,
最新推荐文章于 2024-07-06 13:51:47 发布
SELECT code
FROM stock
GROUP BY code
HAVING COUNT(*) >= 4 AND MIN(huanshoulv) >=10 and min(danqianjia) >=0 and sum(zhandifu) <10