select distinct 列名 form 表名 或 select 列名 form 表名 group by 列名
---------------------------------------------------------------------------------- -- Author : htl258(Tony) -- Date : 2010-05-08 16:09:21 -- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) -- Jul 9 2008 14:43:34 -- Copyright (c) 1988-2008 Microsoft Corporation -- Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2) -- Blog : http://blog.csdn.net/htl258 ------------------------------------------------------------------------------------> 生成测试数据表: [tb] IF OBJECT_ID('[tb]') IS NOT NULL DROP TABLE [tb] GO CREATE TABLE [tb] ([id] [int],[col] [nvarchar](10)) INSERT INTO [tb] SELECT '1','A' UNION ALL SELECT '2','A' UNION ALL SELECT '3','B' UNION ALL SELECT '4','B' UNION ALL SELECT '5','C' UNION ALL SELECT '6','C' UNION ALL SELECT '7','C' UNION ALL SELECT '8','B' UNION ALL SELECT '9','A'--SELECT * FROM [tb]-->SQL查询如下: select distinct col from tb /* col ---------- A B C(3 行受影响) */ select min(id) id,col from tb group by col /* id col ----------- ---------- 1 A 3 B 5 C(3 行受影响) */
或
select 列名 form 表名 group by 列名
-- Author : htl258(Tony)
-- Date : 2010-05-08 16:09:21
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul 9 2008 14:43:34
-- Copyright (c) 1988-2008 Microsoft Corporation
-- Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2)
-- Blog : http://blog.csdn.net/htl258
------------------------------------------------------------------------------------> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb] ([id] [int],[col] [nvarchar](10))
INSERT INTO [tb]
SELECT '1','A' UNION ALL
SELECT '2','A' UNION ALL
SELECT '3','B' UNION ALL
SELECT '4','B' UNION ALL
SELECT '5','C' UNION ALL
SELECT '6','C' UNION ALL
SELECT '7','C' UNION ALL
SELECT '8','B' UNION ALL
SELECT '9','A'--SELECT * FROM [tb]-->SQL查询如下:
select distinct col from tb
/*
col
----------
A
B
C(3 行受影响)
*/
select min(id) id,col from tb group by col
/*
id col
----------- ----------
1 A
3 B
5 C(3 行受影响)
*/