select * from (SELECT *,MIN(huanshoulv) as minh,min(zhandifu) as minz ,sum(zhandifu) as sumz
FROM (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY code ORDER BY date desc) AS row_num
FROM stock
) AS sub_query WHERE row_num <= 3 GROUP BY code) as hh WHERE minh >=10 and minz >=0 and sumz<10
查询最新的3条数据,总和,最小值,有判定条件
最新推荐文章于 2024-07-22 15:12:37 发布