MYSQL - 文章分类 - 幸福之家128817

摘要：SELECT count(distinct uid) FROM `two_users` 阅读全文

posted @ 2013-07-30 18:33 幸福之家128817 阅读(1139) 评论(0) 推荐(0)

摘要：SELECT GREATEST( sender_id, recipient_id ) , LEAST( sender_id, recipient_id ) , COUNT( * ) AS aFROM `pmsg`GROUP BY CONCAT( GREATEST( sender_id, recipient_id ) , LEAST( sender_id, recipient_id ) )ORDER BY a DESCLIMIT 3 注：sender_id：是指发件人id，recipient_id是指收件人id 阅读全文

posted @ 2013-07-26 09:59 幸福之家128817 阅读(112) 评论(0) 推荐(0)

MYSQL查询数据去重用法

摘要：SELECT DISTINCT `uid` , `username` , `name` , `phone` , `sex` , `age` , timeFROM `two_users`GROUP BY uid order by time asc注：distinct要放在前面，不然会报错阅读全文

posted @ 2013-07-25 15:20 幸福之家128817 阅读(509) 评论(0) 推荐(0)

文章分类 - MYSQL