dony_feng的专栏

select * from tb where a2 in (select a2 from tb group by a2 having(count(*)>1))

 http://blog.youkuaiyun.com/chinmo/archive/2008/03/15/2184020.aspx

建立数据库create database test;go--建立表customerscreate table customers(id int identity(1,1) not null,name varchar(15),age int,primary key(id));go--建立表orderscreate table orders(id int identity(1,1) not null,

IDObject TypeSQL Server 2000SQL Server 20051Data ModelsTable = dtpropertiesSELECT * FROM dbo.dtpropertiesGO Table = dbo.sysdiagramsSELECT * FROM dbo.sysdiagrams;GO

from 表1 inner join 表2 on 表1.字段号=表2.字段号

SELECT     表名       = case when a.colorder=1 then d.name else end,    表说明     = case when a.colorder=1 then isnull(f.value,) else end,    字段序号   = a.colorder,    字段名     = a.name,