现在有两张表:
表一:文章 aid uid title content
表二:用户 uid name pwd regdate现在想实现把各个用户所关联的文章数目统计出来,然后按文章总数从多到少排列。
请问这SQL查询怎么写,谢谢!谢谢!
表一:文章 aid uid title content
表二:用户 uid name pwd regdate现在想实现把各个用户所关联的文章数目统计出来,然后按文章总数从多到少排列。
请问这SQL查询怎么写,谢谢!谢谢!
from tb1
join tb2 on tb1.uid=tb2.uid
group by tb2.uid,tb2.name
order by num desc
select u.uid,count(w.aid) cnt
from 用户 U
left join 文章 W
on w.uid=u.uid
order by cnt desc
from 文章 a,用户 b
where a.uid=b.uid
group by name
order by count(*) desc
from 用户 U
left join 文章 W
on w.uid=u.uid
group by u.uid ---3#shao le
order by cnt desc
where 文章.uid=用户.uid
group by name
select 用户.name,COUNT(文章.aid) from 文章,用户
where 文章.uid=用户.uid
group by name
order by COUNT(文章.aid) desc
select a.uid,a.name,count(b.aid) num
from 用户 a
left join 文章 b
on a.uid=b.uid
group by a.uid,a.name
order by num desc
谢谢。