第一个,其实也就是分组的概念 一个是必须Bar_No,Out_Date,Color_NO,pf_order_NB都相同才认为是一组,一个是Bar_No相同就认为是一组,能一样吗第二个,SELECT * FROM( SELECT ROW_NUMBER()OVER(ORDER BY Out_Date)RN ,* FROM v_22 )T WHERE RN=1
少了个东西SELECT * FROM( SELECT ROW_NUMBER()OVER(PARTITION BY Bar_No ORDER BY Out_Date)RN ,* FROM v_22 )T WHERE RN=1
SELECT * FROM( SELECT ROW_NUMBER()OVER(PARTITION BY Bar_No,Color_NO ORDER BY Out_Date)RN ,* FROM v_22 )T WHERE RN=1呃,没注意,你试试这个
select * from( select ROW_NUMBER() OVER(PARTITION BY colthno,left(color,2) ORDER BY outdate) RN,outdate,colthno,LEFT(color,2) color from BI_RK ) T where RN=1
一个是必须Bar_No,Out_Date,Color_NO,pf_order_NB都相同才认为是一组,一个是Bar_No相同就认为是一组,能一样吗第二个,SELECT * FROM(
SELECT ROW_NUMBER()OVER(ORDER BY Out_Date)RN
,*
FROM v_22
)T
WHERE RN=1
SELECT ROW_NUMBER()OVER(PARTITION BY Bar_No ORDER BY Out_Date)RN
,*
FROM v_22
)T
WHERE RN=1
SELECT ROW_NUMBER()OVER(PARTITION BY Bar_No,Color_NO ORDER BY Out_Date)RN
,*
FROM v_22
)T
WHERE RN=1呃,没注意,你试试这个
select ROW_NUMBER() OVER(PARTITION BY colthno,left(color,2) ORDER BY outdate) RN,outdate,colthno,LEFT(color,2) color from BI_RK
) T
where RN=1