如何在SQL Server 2008中获取所有列的重复ID

问题描述

我有一个表，其中的列是ID，USR_ID，MachineName，MachineIP，StartTime，EndTime，TimeLastSeenConnected，SystemLogout，LoggedFrom

该表中有重复的ID.

我写了一个查询以获取重复的行.

Hi,

I have a table with columns are ID,USR_ID,MachineName,MachineIP,StartTime,EndTime,TimeLastSeenConnected,SystemLogout,LoggedFrom

in this table duplicates id''s are there.

i wrote a query to get duplicate rows.

select ID ,COUNT(ID) from tblecsession
group by ID
having (COUNT(*) > 1)

结果:

Result:

032nec45vgdxbg45n0k12v45    2
0cqisn551oongjuxv1oapo45    2
0f2qcq45n1c1xr5554ef4sn1    2
0kf1xmz1x54fpb453ywii455    2
0tunqy55lmrvbsfyqj2oqavf    2
1s0p3jfrugdhllrg10xdc055    3
1t3f3x45xx4x5dqcv4tjxi45    2
1wtslhi5ubvazv45kslctiq1    2
201wg4usv2vberftbzepy02s    2
22limrqd2i3yhaiuwsigpm55    2
2c1duhymwhfa0dnauhhfmfas    2
2ov5fl55cg5n2j55in4ygq55    2
3bkwnr55qo3fcjjlqrmliofo    2
3y2hn5v0jz3dol55a1q5r5m0    2
4brgztiu4q5l3i45cql4r145    2
4dpq0v45b4vrtb45a0awfb45    2
4dsv5t555nqjpv55yjmoi045    2
4vsug255uilni4rql3yqim55    2
4yaoo2isb3gccw45bmlsdz45    2
505wuj55dohfh0iwaolbbqv5    3
53xggw45zkupo1ayjdacg245    3
5bsuzzewiw0liw2rxyg1qzus    2
5laudl23umwkap45t32xce45    2
5m2szzny1cjydu55p1oqvy45    2
5oui5c4514puwj55myaboy55    2
a14j2b45ogkw1fq254kvzg55    2
ai5eytnfhbr25lekqsas2x55    2
app5kg45znie3445ikgt4vvr    2
arn3s155ped11lzokb0w0amk    2
arwgtlfoe44ncxf0yqbqzibq    2
bflkve55lz0ebritfbf3we55    2
bgmwmomwxdcpr055ku0yu0jl    3
bjmic0nqxcc5mr550kxw5x45    2
bt4rda450b2pw2meeanh4e2q    2
bzqqeo45et40trq4pc2qmna1    2
c40s5qu2xa0nd0j2gboogsqf    2
cc4x0r55oew4zx55kvcqgz45    2
cw4drr55hyss1r45nwfwwwix    2
db52lv45c1tvob55sgndja3u    5
ddxgal45q1josjqzxtpxy055    2
dj3vts45d5as0r45chns1145    2
dpxvcg5504m53unajwrrmbfr    2
dttkca45csqj5j55fucas1ns    2
e2dhsb45fo1y4m45b2xwme55    2
ebkk1o45trt0cwugo2rpvtvi    2
epv3idbs4hqvfpzazdfibuul    2
euqurk2z0erlbp45xbl2vxbq    3
ffrjlb45dpua0wuxq0poa5rc    2
fjzjlqatfe2mdczeww5x4055    2
fyq2hkrwxfwgre555kvxk3u4    2
gbsgw2eanuczk345tt3lj045    2
gnhife552q5iyqra0owcyvri    2
grfc4n45o3l5stnalq0w5xro    2
ha1muhaj0e3pv2qurn153r45    4
hesd2t550erkxtqcvxq33t55    2
hjwsb5eoruohb445sbc4ig45    2
hoydog45fg1cqky5fp3l4v55    2
hsabxc55nfhifdaofugc3e55    2
i02z5b45r3pnanjysk1cgwan    2
imzmkn55oh1ju0u0slnpxdif    2
ipbbr131nolpbge1i3e2skyd    2
ixtrrq55ml3e4045f4fju2rr    2
jehvxnufygikrqmo4wh1io55    5
k33maf55sysrrxqjj3wsyrby    2
kolwswywgaip3l55zmrzg445    4
l30w2145v4ft1zfshzptqkml    2
lagtho55pjrl3245z5fm4peb    2
laiotq2emgrrqy4543n425mk    2
ldmhq2rezldyo0qbqj5ulbbl    2
lebyeb555ofcfmm3pvmg3o55    2
lfpwrx45mg2l3h55abh2krmm    2
ll0ugev4fsxdwwegb3xtupb1    2
lrgru255euj3xfylymfp3gev    2
lzmyesbrmxhr0d45m4rywlnz    2
mgwy50qhrg1ey5i44aijcfii    2
mjczgy553jwxyd45sjqpa1aa    2
mjp01i55kbf5ppao0tzsoh55    2
mptruq45ecwnon45zrrrmb55    2
mwjs052pbsskwffgijdnzhrb    2
nbywes452jnfd3aqzfjpxr45    3
netreg55bpqj4dzlqz5rv445    2
nywshfusilsrhc45ziyqxszd    2
oscwx3j2solc24y1wd3s1peu    2
p3dsol45cnd4y045y1fswa55    2
p4tcps3imqtrmhn5lxmxuc45    2
pbqheqvberjesq3icqojneum    2
pq5uiwzj4zktrp45ha3v0455    2
pssnin45eqjv3s55gwebns55    2
qe4r0f4550sgc045io3ap1u5    2
qlxgxhmzqnbrdkizci33np55    2
rfbn3xmqcypjbv205j3ya2jb    3
rwxehq55nthm5e45rjp5wq55    2
sa34lofe1sskvrrz1nzx5b55    2
sgvwl2rzjzyfcvmsx4fhugmo    2
shksxi55wtlxeg45bprcqd55    2
sxmt3q45wkeun0554i1fs5jd    2
tutatsiw43hcs2yivm2knqa3    2
ur345555kcxjug453ev5og55    2
utqsch552w5svw55tfqiwp55    2
v2iiegekdbv5cr55jdslixrm    2
vlol2oibhrj0j545m1p5jmfa    3
vmr1et45ywmuf2ym2plehj55    2
vy55qu45ijbywa551cmlcl45    2
wkiktw453xnxz5ybew3bdwmd    2
woq1wffdkiq3rlz13xnt222a    2
x4xlkm55kki5o2qdpzqeva45    2
xbqegbequkzocmqjlqq1yfrz    2
zskf4x45hm0hb1vdacpins45    2

但我想复制id和所有列

如何编写查询?

but i want dulpicates id''s along with all columns

how to write query ?

is it possible to get?

推荐答案

Select * from tblecsession where Id in

(select ID from tblecsession
group by ID
having (COUNT(*) > 1))

这篇关于如何在SQL Server 2008中获取所有列的重复ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！