select FolderName,(select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id) as Numb from KS_Class where TN="20093806144224"----这条SQL语句,我想把它的结果按Numb排序,可是我在where子句后面接 order by Numb 它就报错没有加order by子句的结果如下:
FolderName Expr1001
吉首交管动态 1
花垣交管动态 2
凤凰交管动态 1
龙山交管动态 2
永顺交管动态 112
泸溪交管动态 0
保靖交管动态 0
古丈交管动态 0
州支队交管动态 7 我要按后面的数字排序哦,sql是对MS-Access数据库操作的
FolderName Expr1001
吉首交管动态 1
花垣交管动态 2
凤凰交管动态 1
龙山交管动态 2
永顺交管动态 112
泸溪交管动态 0
保靖交管动态 0
古丈交管动态 0
州支队交管动态 7 我要按后面的数字排序哦,sql是对MS-Access数据库操作的
-2147217904 至少一个参数没有被指定值。 Microsoft JET Database Engine 5000000
FROM
(select FolderName,
(select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id) as Numb from
KS_Class where TN="20093806144224") AS T
ORDER BY NUMB
select FolderName,
(select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id) as Numb from
KS_Class where TN="20093806144224"
ORDER BY (select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id)
SQL77
(77C#+SQL)
我先谢谢你了,(悄悄的对你说一句:我的问题还没解决);
不知道你用过科讯CMS V5.5 版本吗,我的SQL语句就是从它里面的数据库对其相应的栏目,统计栏目里的文章总数,并对统计结果进行排序,我要的就是这个功能。我想用sql实现,哎!怎赖我的技术不行啊
(select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id) as Numb from
KS_Class where TN='20093806144224'
ORDER BY (select count(id) as num from KS_Article where KS_Article.Tid=KS_Class.id)
改单引号试试呀???二楼也说了呀,呵呵
FolderName,
(select count(Tid) as num from KS_Article where KS_Article.Tid=KS_Class.id) as Numb
from KS_Class
where TN='20093806144224'
order by Numb
select ks_class.foldername,count(ks_article.id) as num from ks_class left join KS_Article on ks_article.tid=ks_class.id where ks_class.tn='20093806144224' group by ks_class.foldername order by count(ks_article.id)因为我写的那个sql语句是操作MS access数据库的,所以你们有好些方法到别的dbms里面应该是可以运行的,我要再次谢谢你们的关注!
你会这写的话,你的问题应该就可以解决了的!