剔除掉重复数据,只显示没有重复的列。
USE database_name
GO
SELECT DISTINCT [column_name] FROM [dbo].[table_name]
USE
database_name
GO
SELECT DISTINCT [ column_name ] FROM [ dbo ] . [ table_name ]
-- DISTINCT 关键词,查询没有重复的,唯一的列数据
GO
SELECT DISTINCT [ column_name ] FROM [ dbo ] . [ table_name ]
-- DISTINCT 关键词,查询没有重复的,唯一的列数据
--