解决方案 »
- Log Explorer支持sqlserver2005吗?哪个版本?
- 关于数据表在两个数据库之间复制出现的问题
- 对三条简单的SQL语句执行后的结果不太理解,请各位帮忙指点!
- 请问SQL语句中如何让多列重复的记录只保留一条记录,其它的数据正常显示
- CRecordSet Open
- 问个sql语句
- 关于邮件报警监控作业执行情况
- sql = "ALTER TABLE awc_liuyan1 ADD COLUMN Notes char(10)" 怎么老是报错
- 征集系统存储过程的解释和例子,按条给分
- 我再问一个问题哟,怎么查询数据里只包含几种数的SQL语句呢?
- sql语句
- SQL Server 2005 无法使用row_number..
FROM NEWS INNER JOIN
ADMIN ON NEWS.Author = ADMIN.UserName INNER JOIN
DanWei ON ADMIN.Bumen = DanWei.ClassID group by DanWei.ClassName
??????????
FROM NEWS INNER JOIN
ADMIN ON NEWS.Author = ADMIN.UserName INNER JOIN
DanWei ON ADMIN.Bumen = DanWei.ClassIDGROUP BY DanWei.ClassName你要统计肯定要分组吧
count(*) as CountS,DanWei.ClassName
FROM
NEWS INNER
JOIN
ADMIN
ON
NEWS.Author = ADMIN.UserName
INNER JOIN
DanWei
ON
ADMIN.Bumen = DanWei.ClassID
group by
DanWei.ClassName --------前面有聚合函数 这里需要GROUP BY
FROM NEWS INNER JOIN ADMIN ON NEWS.Author = ADMIN.UserName
INNER JOIN DanWei ON ADMIN.Bumen = DanWei.ClassIDgroup by DanWei.ClassName
count(*) as CountS,DanWei.ClassName
FROM
NEWS
INNER JOIN
ADMIN
ON
NEWS.Author = ADMIN.UserName
INNER JOIN
DanWei
ON
ADMIN.Bumen = DanWei.ClassID
group by
DanWei.ClassName --------前面有聚合函数 这里需要GROUP BY
order by
count(*)
SELECT
名次=row_number()over(order by CountS),ClassName,CountS
from
(select
count(*) as CountS,DanWei.ClassName
FROM
NEWS
INNER JOIN
ADMIN
ON
NEWS.Author = ADMIN.UserName
INNER JOIN
DanWei
ON
ADMIN.Bumen = DanWei.ClassID
group by
DanWei.ClassName --------前面有聚合函数 这里需要GROUP BY
order by
count(*))t
FROM NEWS INNER JOIN
ADMIN ON NEWS.Author = ADMIN.UserName INNER JOIN
DanWei ON ADMIN.Bumen = DanWei.ClassIDGROUP BY DanWei.ClassNameORDER BY 1