请问一个查询语句! select StreetName,count(*) as countsfrom Communication as cgroup by StreetNameorder by c.counts 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select StreetName,Count(*) as Sl from 表 group by StreetName order by Sl select streetname, sum(1) 人数 from communicationgroup by streetnameorder by sum(1) select StreetName,Count(*) as Sl from Communicationgroup by StreetName order by Sl select StreetName,Count(1) as Sl from Communication group by StreetName order by Sl --我记得别名不能用在order by后面的,sorry! select streetname, sum(1) 人数 from communicationgroup by streetname order by sum(1) 对不起,忘记了一点,就是这一查询要建立在另一个字段项相同的情况下。比如同一区。区字段用area表示 。 这个查询可以描述为:将表中一个字段值相同的记录统计,并按统计数的大小排出。比如Communication表,其中有两个字段area,StreetName,我想同一area中,住在同一条街的人数,并按人数多少顺序列出,并且也要列出其所属area.请帮我写个SQL查询语句?如何办? select Area,StreetName,Count(*) as Sl from Communicationgroup by Area,StreetName order by Sl select Area,StreetName,Count(*) as Number from Communication group by Area,StreetName order by Number MS SQL 2005 CPU 性能监控 自动发送邮件 水平较低 能否帮助精简一下SQL语句。 请教一菜问题,分析器如何调试有返回值的存储过程 新手出道,面试题! 求SQL:入库时存在更新库存数,不存在插入记录 求一sql语句 問一個簡單的SELECT語句。A表 - B表 高手帮忙:如何把mssql数据库中的数据生成到.sql 成 insert into ......等 怎么把.dwg CAD文件存到SQL SERVER表中的image类型的字段中去? 如何在vfp6.0中操作文件 ODBC Call Failed run time error '3146' 游标嵌套使用
group by streetname
order by sum(1)
group by StreetName order by Sl
group by streetname order by sum(1)
如何办?
group by Area,StreetName order by Sl