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...
CREATE TABLE tab ( exdate date , vendor char(2) , product Nvarchar(20) );...
純真的人的鐵人檔案