MySQL:选择唯一值 [英] MySQL: SELECT UNIQUE VALUE

问题描述

在我的表中，我有几个重复项.在mysql表列中查找唯一值.

In my table I have several duplicates. Ineed to find unique values in mysql table column.

SQL

SELECT column FROM table
WHERE column is unique

SELECT column FROM table
WHERE column = DISTINCT

我一直在尝试使用Google，但是几乎所有查询都更加复杂.

I've been trying to Google, but almost all queries are more complex.

我想要的结果是所有非重复值.

The result I's like is all non duplicate values.

编辑 我想拥有UNIQUE值...

EDIT I'd like to have UNIQUE values...

不是一次所有值...(不同)

Not all values one time... (Distinct)

推荐答案

尝试使用 DISTINCT 像这样:

SELECT DISTINCT mycolumn FROM mytable

尝试

select mycolumn, count(mycolumn) c from mytable
group by mycolumn having c = 1

这篇关于MySQL:选择唯一值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！