php 怎么查询不重复的记录?需要查询好多个字段,包括id,username,proname....,有个要求是username不重复,怎么实现?原sql是select vid,username,proname,phone...from userlist order by vid desc limit 0,50
select vid,username,proname,phone...from userlist group by username order by vid desc limit 0,50
要查id,SQL语句居然没有id列,1楼的代码可以 select id,vid,username,proname,phone...from userlist group by username order by vid desc limit 0,50
select vid,title,protype,price,shuliang,username,adddate,xingming,sheng,qq,phone,tuiguang,tuoguan from gongyinglist group by username order by adddate desc limit 0,22 本来是按照信息发布日期排列,怎么加上group by username后排列顺序就不对了?
select id,vid,username,proname,phone...from userlist group by username order by vid desc limit 0,50
本来是按照信息发布日期排列,怎么加上group by username后排列顺序就不对了?