当前位置: 代码迷 >> Sql Server >> [疑难杂证]求救解决方案
  详细解决方案

[疑难杂证]求救解决方案

热度:94   发布时间:2016-04-27 18:54:07.0
[疑难杂证]求救
我原来的句子是这样的,可以运行.
select   ChannelID,ClassID,Title,count(*)   from   PE_Article
group   by   ChannelID,ClassID,Title
having   count(*)> =2   and   ChannelID= '1035 '
但我在里面加了字段Content.
select   Content,ChannelID,ClassID,Title,count(*)   from   PE_Article
group   by   Content,ChannelID,ClassID,Title
having   count(*)> =2   and   ChannelID= '1035 '
就发生错误了.我Content是ntext类型的.请问怎么修改才能正确的显示数据..


------解决方案--------------------
select substring(Content,1,4000),ChannelID,ClassID,Title,count(*) from PE_Article
group by substring(Content,1,4000),ChannelID,ClassID,Title
having count(*)> =2 and ChannelID= '1035 '
------解决方案--------------------
select a.Content,b.* from PE_Article a,(
select ChannelID,ClassID,Title,count(*) aou from PE_Article
group by Content,ChannelID,ClassID,Title
having count(*)> =2 and ChannelID= '1035 ')
where a.ChannelID=b.ChannelID
------解决方案--------------------
--try


select a.Content,b.* from PE_Article a,(
select ChannelID,ClassID,Title,count(*) aou from PE_Article
group by Content,ChannelID,ClassID,Title
having count(*)> =2 and ChannelID= '1035 ') b
where a.ChannelID=b.ChannelID

------解决方案--------------------
text,ntext,image类型的列不能用于group by.
------解决方案--------------------
select Content=cast(Content as varchar),ChannelID,ClassID,Title,count(*) from PE_Article
group by cast(Content as varchar),ChannelID,ClassID,Title
having count(*)> =2 and ChannelID= '1035 '
  相关解决方案