select distinct(user) from (select count(user) as usernum,user from news group by user) as A order by usernum DESC数据表是一个多作者发布新闻的新闻表,我想实现的功能是:按照作者发表新闻的多少排序,列出作者的名字。上面是一个SQL-server的语句,请问ACCESS数据库应该用什么养的语句才能实现这个功能?谢谢!
调试欢乐多
from news
group by user
order by usernum DESC
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
insert into @news
select 'w','ww'
union all
select 'q','qq'
union all
select 'w','ww'
select * from @news
select distinct [user],count([user]) as Num
from @news
group by [user]
order by 2 desc
--原始数据:
user context
---------------
w ww
q qq
w ww
--运行结果:
user Num
----------------
w 2
q 1
ODBC 驱动程序不支持所需的属性。郁闷!!
select user, count(user) from news group by user
order by count(user) desc