如何从具有重复值的列中获取唯一值 [英] how to get unique values from a column with duplicate values in it

问题描述

如何从列中包含重复值的列中获取唯一值

how to get unique values from a column with duplicate values in it

推荐答案

请通过此链接 http://www.w3schools.com/sql/sql_distinct.asp [ ^ ]

Pls go through this link http://www.w3schools.com/sql/sql_distinct.asp[^]

select distinct columnName from TableName

使用distinct来elimante副本。





从TABLE_NAME中选择DISTINCT（COLUMN_NAME）

Use distinct to elimante the duplicate.


Select DISTINCT(COLUMN_NAME) from TABLE_NAME

简单：

Simple:

SELECT DISTINCT [YourTable].[YourColumn] FROM [YourTable]

DISTINCT 关键字允许您去掉duplicat来自您的查询结果。

DISTINCT keyword allows you to strip off duplicates from your query results.

这篇关于如何从具有重复值的列中获取唯一值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！