参考链接:
https://jingyan.baidu.com/article/64d05a0214cba1de55f73bf1.html
一、去掉查询结果中重复的内容
SELECT DISTINCT planeNumber from planeinfo ORDER BY planeNumber
二、读取表中不重复的数据
SELECT planeModel, planeNumber from planeinfo
GROUP BY planeModel, planeNumber
参考链接:
https://jingyan.baidu.com/article/64d05a0214cba1de55f73bf1.html
一、去掉查询结果中重复的内容
SELECT DISTINCT planeNumber from planeinfo ORDER BY planeNumber
二、读取表中不重复的数据
SELECT planeModel, planeNumber from planeinfo
GROUP BY planeModel, planeNumber