表User 字段username,password,lastlogin...
表Article 字段title,content,username这2个表通过username关联现在对User表按照其username在Article发表文章总数进行降序排列,发表文章总数最多的排在第一。
表Article 字段title,content,username这2个表通过username关联现在对User表按照其username在Article发表文章总数进行降序排列,发表文章总数最多的排在第一。
select m.username , count(*) 发表文章总数
from User m,Article n
where m.username = n.username
group by username
order by 发表文章总数 desc , username
order by sum(case when b.username is null then 0 else 1 end) desc
from User m left join Article n
on m.username = n.username
group by username
order by 发表文章总数 desc , username
select * from User,(select username,count(*) as allnum)t
where user.username=t.username
order by t.allnum desc
select b.* from User b inner join (select username ,count(*)as id_ from Article group by username )Article
on b.username =Article.username order by Article.id
select b.* from User b inner join (select username ,count(*)as id_ from Article group by username )Article
on b.username =Article.username order by Article.id