Question

access中的SQL语句，语法错误，操作符丢失

select author,count(author)from article
where title in(
select title from article
where author='H. Vincent Poor'
)
and author!='H. Vincent Poor'
group by author
having count(author)>5
order by count(author) desc
;

Answer 1

不等号写错了
select author,count(author)from article
where title in(
select title from article
where author='H. Vincent Poor'
)
and author<>'H. Vincent Poor'
group by author
having count(author)>5
order by count(author) desc
;

追问

您好，修改之后，倒是不报错了。。可是一直显示“正在执行查询”。这是陷入死循环了么

追答

那就看下是不是你数据本身问题咯，你建一个空表来执行这条语句试试看哈