保留錯的版本 check 想了一下groupby好像就不太需要用count... select VENDOR,MONTH, RNK1 產品1,NVL2(RNK2...
SELECT ym,vendor,p1,concat(if(p1=p2,'還是',''),p2) FROM ( SELECT ym,vendor, SUBST...
create table tab ( vendor varchar(20) , exdate date , product varchar(20) )...
SELECT ym,vendor,SUBSTRING_INDEX(GROUP_CONCAT(product),",",2) FROM (...
check select * from ( select rank() over(partition by vendor,trunc(ex...
純真的人的鐵人檔案