具体的sql语句如下:
select ordersID,danwei,lxr,tel,email,usernames,id,yd from tb_order where id in(
select MAX(ID) AS ID from tb_order group by ordersID --查询不重复的ID
) order by ordersID desc
查询一个表里需要显示的字段,且不出现重复的记录。
具体的sql语句如下:
select ordersID,danwei,lxr,tel,email,usernames,id,yd from tb_order where id in(
select MAX(ID) AS ID from tb_order group by ordersID --查询不重复的ID
) order by ordersID desc
查询一个表里需要显示的字段,且不出现重复的记录。