摘要:
select * from(select *, ROW_NUMBER() over(partition by accountid order by opentime DESC) as rowNumfrom ep_productopenhistoryWHERE accountid IN(SELECT accountid FROM dbo.ep_accountnoWHERE name IN ('1334760','1334761','1334762','1334763','1334764','1334765 阅读全文