MySQL 查询去重
MySQL 大约 1067 字DISTINCT
distinct name
是去除name
字段的重复值,返回name
字段列
select distinct name from user;
+-------+
| name |
+-------+
| zs |
| admin |
| loso |
+-------+
distinct name,home
是去除name
和home
共同重复的值并且返回
select distinct name,home from user;
+-------+-------+
| name | home |
+-------+-------+
| zs | China |
| admin | China |
| loso | China |
| zs | xx |
+-------+-------+
GROUP BY
select * from user group by name;
+----+-------+------+---------------------+--------+-------+----------+
| id | name | age | birthday | gender | home | isdelete |
+----+-------+------+---------------------+--------+-------+----------+
| 0 | admin | 0 | 2000-01-01 00:00:00 | | China | |
| 2 | loso | 10 | 2000-01-01 00:00:00 | | China | |
| 1 | zs | 10 | 2000-01-01 00:00:00 | | China | |
+----+-------+------+---------------------+--------+-------+----------+
LIMIT 1
ORDER BY
时间字段 desc LIMIT 1`
SELECT * from org_phone_num WHERE `remove`=0 and phone = '073188872151' ORDER BY last_modified desc LIMIT 1;
阅读 1875 · 发布于 2019-04-06
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓

昵称:
随便看看
换一批
-
使用 trivy 扫描 Docker 镜像、K8S 集群的安全漏洞阅读 686
-
Android 软键盘遮挡控件阅读 1541
-
iView Tag 标签点击事件阅读 1937
-
k3s Helm Error INSTALLATION FAILED Kubernetes cluster unreachable阅读 2250
-
MySQL 查询去重阅读 1875
-
Kubernetes kubectl cp 命令报错 error: unexpected EOF阅读 466
-
Redis 查看连接数阅读 2490
-
Nginx 配置之解决 413 错误(Request Entity Too Large)阅读 5138
-
Linux 网络状态工具 ss,代替 netstat阅读 13756
-
MySQL 之 MyISAM 和 InnoDB 区别阅读 1958