不行了！！快来帮帮忙啊 …………………………………………………………

[loveqian007]

现在有几个记录作者发表论文的数据表，我想把这些表中发表论文篇数>10篇的作者统计出来该怎么做啊

[jarraytan]

用group ,having
select count(title),author from tab group by author having count(title)>10

[jarraytan]

大概语句如此了，你再根据自己的需要修改下吧。

[loveqian007]

我这个是多个数据表
怎么弄啊

count(title)是什么意思啊

[flashixj61]

做个小小的存储过程吧：
drop proc count_wz
go
create proc count_wz
as
--将几个表中需要统计的数据插入一个临时表(比如统计文章数(文章名为title),作者名)
select count(title) as title, author_name into #lsk from tableA group by author_name
insert into #lsk()
select count(title) as title, author_name from tableB group by author_name
insert into #lsk()
select count(title) as title, author_name from tableC group by author_name
...
--插入之后重新统计一下就可以输出了
select count(title) as title, author_name from #lsk group by author_name
go

[loveqian007]

select count(title) as title, author_name into #lsk from tableA group by author_name这句话在asp中怎么才能用起来啊