sql 语句 高手来看

[symbol_bc]

select col1,col2,col3,count(*) as [count]
from @temp
group by col1,col2,col3 having [count] > 1
总说[count] 不能识别


请问应该怎样写

[imfor]

count 是关键字 换成别的就可以了

[code=VB]select col1,col2,col3,count(*) as [ALLcount] 
  from @temp 
  group by col1,col2,col3 having [ALLcount] > 1 

[/code]

[Aderlee]

因为[count]不属于@temp

select A.* from
(select col1,col2,col3,count(*) as [count]
from @temp
group by col1,col2,col3) A where [count] > 1

[fluat]

count是关键字啊

[lixinramaxel41658133]

select CorporateNo,count(*) from LMS_Centerlist
group by CorporateNo having count(*)>1

[wujinjian2008n]

select col1,col2,col3,count(*) as [count] 
  from @temp 
  group by col1,col2,col3 having count(*) > 1 

[lixinramaxel41658133]

select col1,col2,col3,count(*) as [count] 
  from @temp 
  group by col1,col2,col3 having count(*) > 1 

[tel[phone]]

应该是count(*)才对因为是统计的条数嘛

[lixinramaxel41658133]

select col1,col2,col3,count(*) as [count] 
  from @temp 
  group by col1,col2,col3 having count(*) > 1 

[tel[phone]]

应该是count(*)才对因为是统计的条数嘛

[阿非]

和你之前问的问题是一样的，不能使用别名

select col1,col2,col3,count(*)
  from @temp
  group by col1,col2,col3 having count(*) > 1 

[沉序员]

gggggggggggggggggg

[hassy070123]

good!!!!!

[jack15850798154]

把Count换成别的别名不就行了吗？

[hzj170]

[Quote=引用 6 楼 lixinramaxel41658133 的回复:]
C# codeselect col1,col2,col3,count(*)as [count]from @tempgroupby col1,col2,col3 having count(*)>1
[/Quote]
这样应该可以。。

[阿非]

declare @t table(
name varchar(10)
)
insert into @t select '1'
insert into @t select '2'
insert into @t select '3'
insert into @t select '4'
insert into @t select '4'
select * from @t
select name from @t group by name
--select name n from @t group by n
select *  from (select name n from @t) t group by n
select name,[COUNT] from (select name,COUNT(*) [count] from @t group by name) t group by name,[count] having [count]>1

[zzxap]

可以使用别名的

[zzxap]

select id,count(name) as asd from t2 group by id having count(name)>2

不能使用别名的，记错了