2013年9月12日
sql去重
摘要： select id,OrderID,Mobile,Name from (select id,OrderID,Mobile,Name from V_Order where len(isnull(Mobile,''))>0 and State=0) Customer where id in (select min(id) from (select id,OrderID,Mobile,Name from V_Order where len(isnull(Mobile,''))>0 and State=0) Customer group by Mobile 阅读全文
posted @ 2013-09-12 18:20 一千零一夜 阅读(478) 评论(0) 推荐(0)