SQL视图问题,A列值相同时,将B列最小值所对定的C列选出来
答案:2 悬赏:30
解决时间 2021-02-19 07:44
- 提问者网友:锁深秋
- 2021-02-18 08:46
SQL视图问题,A列值相同时,将B列最小值所对定的C列选出来
最佳答案
- 二级知识专家网友:几近狂妄
- 2021-02-18 09:20
select * from
(
select id,code,name,ROW_NUMBER() over(PARTITION by
code order by name) as num from tablename
) T where T.num <= 1
order by id
(
select id,code,name,ROW_NUMBER() over(PARTITION by
code order by name) as num from tablename
) T where T.num <= 1
order by id
全部回答
- 1楼网友:举杯邀酒敬孤独
- 2021-02-18 10:48
select *
from 表 W
WHERe ID=(SELECt MIN(ID) FROM 表 WHERe CODE=W.CODE)
from 表 W
WHERe ID=(SELECt MIN(ID) FROM 表 WHERe CODE=W.CODE)
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯