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;
阅读 1458 · 发布于 2019-04-06
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓

昵称:
随便看看
换一批
-
Java 并发编程之 AQS ReentrantLock await signal 源码解析阅读 552
-
通过 Windows 远程桌面修改远程电脑密码阅读 158
-
HTML input 输入框禁止显示输入过的历史数据阅读 745
-
GoJS 更改 Overview 的拖动框颜色阅读 413
-
Java 并发编程之 ThreadPoolExecutor 线程池源码解析阅读 364
-
HTML 禁止在移动端缩放阅读 688
-
软考-系统架构设计师:信息系统阅读 927
-
Elasticsearch 监控运行状态阅读 1448
-
软考-系统架构设计师:层次化存储结构阅读 889
-
设计模式之享元模式阅读 1509