order by 与group by同时使用的sql语句问题,谢谢。给分! 因为character不再group by的字段之内,必须是一个统计函数,例如max(character)。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT NClass, character, COUNT(*) AS recsFROM NClassGROUP BY NClass, characterORDER BY character --按NClass, character进行分组SELECT NClass, character, COUNT(*) AS recsFROM NClassGROUP BY NClass, characterORDER BY NClass, character 先GROUP BY ,再ORDER BY 我改写成SELECT NClass, character, COUNT(*) AS recsFROM NClassORDER BY characterGROUP BY NClass,character也不对呀。 怎么我得出的count(*)的值是1呀,不对呀,应该得出的是记录的条数呀。 上面已经说了...------------------------------------------------------------------------- 回复人: progress99(如履薄冰) ( ) 信誉:100 2004-04-30 17:27:00 得分:0 先GROUP BY ,再ORDER BY 我的目的是在order和group同时有的情况下得出记录的总条数。谢谢 SELECT NClass, character, COUNT(*) AS recsFROM NClassGROUP BY NClass, characterORDER BY character先GROUP BY ,再ORDER BY 这个语句是可以运行了,但得出来recs等于1. 我想得到这样查询后一共有多少条记录呀。急! SQL SERVER2008 error:26错误 怎么从一个大范围里边去除一定数据 横向分割的2个表,查询时用视图好还是用union好?? 最近学sql欲望很烈,再问一个alter写法 如何通过命令来修改数据表的结构?包括字段名称、数据类型 关于文件编号的问题! insert into问题 请问如何在win200下,建立服务端和客户端,使的客户端可以访问服务端的数据库 小弟刚毕业,不了解用什么数据库,请大侠赐教,学什么数据库最容易 中英文版本下的切换问题,讨教 我有一万个手机串号,和仓库里十万个串号比较有没有重复的,为了加快速度,采用哪一种算法较好. 我想请教一个很小的问题
FROM NClass
GROUP BY NClass, character
ORDER BY character
SELECT NClass, character, COUNT(*) AS recs
FROM NClass
GROUP BY NClass, character
ORDER BY NClass, character
SELECT NClass, character, COUNT(*) AS recs
FROM NClass
ORDER BY character
GROUP BY NClass,character
也不对呀。
-------------------------------------------------------------------------
回复人: progress99(如履薄冰) ( ) 信誉:100 2004-04-30 17:27:00 得分:0
先GROUP BY ,再ORDER BY
FROM NClass
GROUP BY NClass, character
ORDER BY character先GROUP BY ,再ORDER BY
我想得到这样查询后一共有多少条记录呀。急!