摘要:
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 阅读全文