查詢留下較大的水果
uj5u.com熱心網友回復:
那么 多大算大uj5u.com熱心網友回復:
表2 留下的個數uj5u.com熱心網友回復:
select*from (select t1.fruit, row_number() over(partition by t1.fruit order by t1.size desc) rn from tab1 t1) t1,
tab2 t2
where t1.rn <= t2.count
and t1.fruit = t2.fruit;
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/57103.html
標籤:非技術區
