SQL查询不重复某一列的值(其他列重复也不用理)



select OpenID,Max(ID) as 'id',Max(姓名) as '姓名',Max(电话) as '电话',Max(地址) as '地址',Max(归属) as '归属' from gouwuche where 订单情况='未发货' group by OpenID order by Max(ID) desc"








webform
桂ICP备16004754号