Mysql 查询不重复数据

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Mysql 查询不重复数据，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1120字，纯文字阅读大概需要2分钟。

内容图文

用户表

app表

用户记录表

现在要想查出用户点击的记录的列表，并且按照用户，时间排序，去掉重复的数据

select distinct a.* from (select n.name,u.phone,n.startmoney,n.endmoney,n.type from loan_record r
inner join loan_user u on u.id=r.uid
inner join loan_name n on n.id=r.appid
where r.uid in (select distinct uid from loan_record order by createdate desc) order by u.phone,r.createdate desc) as a
where a.name='微贷'

如果不去掉重复的，直接这样就行了

select u.phone,n.name,n.startmoney,n.endmoney,n.type from loan_record r
inner join loan_user u on u.id=r.uid
inner join loan_name n on n.id=r.appid
order by r.createdate desc;

同时记录下之前写的代码，读者可忽略

select * from (select * from (
 select r.uid as uid,r.cid as cid,c.rank as rank,b.bookname as bookName,b.cover as cover,r.read_date as readDate,
 b.id as bid,b.majorcate as majorCate,b.is_over as isOver
 from record r
 inner join user u on u.id=r.uid and r.uid=#{record.uid}
 inner join chapter c on c.id=r.cid
 inner join book b on b.id=c.bid
 group by r.uid,r.cid
 order by c.rank)aa ORDER BY uid asc,rank desc)cc group by bid ORDER BY readDate desc

内容总结

以上是互联网集市为您收集整理的Mysql 查询不重复数据全部内容，希望文章能够帮你解决Mysql 查询不重复数据所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端