2013年10月9日
挑选分组中top1
摘要： 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&# 阅读全文
posted @ 2013-10-09 11:26 深潭 阅读(252) 评论(0) 推荐(0)