同一张表怎么合并重复记录呢? select distinct uname, cid, dept from tb? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select distinct uname+' '+cid+' '+dept as [uname cid dept]from tb合并的意思是把他们连接起来? select distinct uname,cid,dept from tb if object_id('tb') is not null drop table tbgocreate table tb([uname] varchar(10),[cid] varchar(10),[dept] varchar(10),[function] varchar(20))insert tb select 'Jay','j1110','IT','programming'insert tb select 'jay','j1110','IT','Writing'insert tb select 'Jolin','j9000','FS','ACCOUNTING'insert tb select 'Jolin','j9000','FS','Booking'insert tb select 'mary','m1111','PS','Buying'goselect distinct uname+' '+cid+' '+dept as [uname cid dept] from tb/*uname cid dept--------------------------------Jay j1110 ITJolin j9000 FSmary m1111 PS(3 行受影响)*/select distinct uname,cid,dept from tb/*uname cid dept---------- ---------- ----------Jay j1110 ITJolin j9000 FSmary m1111 PS(3 行受影响)*/ 没有找到,字面意思是这个吧declare @a table(uname varchar(8),cid varchar(8),dept varchar(8))insert into @aselect 'jay','j1110','it'Union allselect 'jay','j1110','it'Union allselect 'jolin','j9000','fs'Union allselect 'jolin','j9000','fs'select distinct uname,cid,dept from @a应该不是这么简单 各位高手们,救命呀! 禁止同时申请订单的问题,快来就我把 C# SQL 编程疑问 每次备份前都会出现这样的提示 查询数据库表数据---请教高手 请高手来帮忙啊~~分不是问题啊 sql备份问题 100送上 在从DataGrid修改数据时,怎么样能同步更新数据库中内容!! 大力,分割字符串问题 sdl,update 中的减负数的问题 数据库中的表的主键的值为什么可以改为不填任何数据 vista安装SQL2005遇到的奇怪问题 SQL SERVER数据库一定走以太网吗?
distinct
uname+' '+cid+' '+dept as [uname cid dept]
from tb
合并的意思是把他们连接起来?
drop table tb
go
create table tb([uname] varchar(10),[cid] varchar(10),[dept] varchar(10),[function] varchar(20))
insert tb select 'Jay','j1110','IT','programming'
insert tb select 'jay','j1110','IT','Writing'
insert tb select 'Jolin','j9000','FS','ACCOUNTING'
insert tb select 'Jolin','j9000','FS','Booking'
insert tb select 'mary','m1111','PS','Buying'
go
select distinct uname+' '+cid+' '+dept as [uname cid dept] from tb
/*
uname cid dept
--------------------------------
Jay j1110 IT
Jolin j9000 FS
mary m1111 PS(3 行受影响)
*/
select distinct uname,cid,dept from tb
/*
uname cid dept
---------- ---------- ----------
Jay j1110 IT
Jolin j9000 FS
mary m1111 PS(3 行受影响)
*/
declare @a table(uname varchar(8),cid varchar(8),dept varchar(8))
insert into @a
select 'jay','j1110','it'Union all
select 'jay','j1110','it'Union all
select 'jolin','j9000','fs'Union all
select 'jolin','j9000','fs'
select distinct uname,cid,dept from @a应该不是这么简单