求教条MYSQL语句 本帖最后由 Xy_SuperMario 于 2011-06-21 15:57:51 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select A.cid,count(1) as total from A inner join B on A.cid = B.cidgroup by A.cid order by total desc http://topic.csdn.net/u/20080110/12/17479e6a-7161-4a2a-b077-71f5661f1397.html select B.* from B ,(select cid,count(*) as num from A group by cid)AA where AA.cid=B.cid order by AA.num desc select t2.fen,t2.cid from B t inner join A t2 on t.cid=t2.cid order by t2.cid desc 我实现类似这样的select cid,fen from B order by select cid from(select count(cid)....)desc.这样能不能实现啊? 按 A.cid 出现的个数降序?select B.* from b, (select cid, count(*) as cnt from A group by cid) c where B.cid=c.cid order by c.cid desc 新手问路 关于 文件夹权限的问题 php与mysql数据库连接的小问题 正则表达式啊,帮忙啊, 网页调用显示的问题? 做这样一个论坛需要多少钱?有人给解答一下 传值的问题 闲着无聊散分玩,好困啊-_- zZZ 有关文件操作的问题 如何才能去掉php的warning信息? 是否有开发文档范例可以拜读拜读? 用php算周3的难题~ 急急急~~~
inner join B on A.cid = B.cid
group by A.cid order by total desc
select cid,count(*) as num from A group by cid)AA where AA.cid=B.cid order by AA.num desc
这样能不能实现啊?
select B.* from b, (select cid, count(*) as cnt from A group by cid) c where B.cid=c.cid order by c.cid desc