Home >Database >Mysql Tutorial >sql 删除重复行(ALL或DISTINCT)

sql 删除重复行(ALL或DISTINCT)

WBOY
WBOYOriginal
2016-06-07 17:50:012096browse

删除重复行SELECT语句中使用ALL或DISTINCT选项来显示表中符合条件的所有行或删除其中重复的数据行,默认为ALL。使用DISTINCT选项时,对于所有重复的数据行在SELECT返回的结果集合中只保留一行

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn