SELECT sum(count1)
,f2_caption
from
( select 0 as count1
,forum_2.f2_caption
,forum_2.f2_id
from online
inner join forum_2 on online.boardid<>forum_2.f2_id
union
select top 2 count(id) as count1
,forum_2.f2_caption
,forum_2.f2_id
FROM online inner join forum_2 on online.boardid=forum_2.f2_id
group by forum_2.f2_caption
,forum_2.f2_id
order by forum_2.f2_id desc
) t
group by f2_caption
,forum_2.f2_id
ORDER BY forum_2.f2_id desc
,f2_caption
from
( select 0 as count1
,forum_2.f2_caption
,forum_2.f2_id
from online
inner join forum_2 on online.boardid<>forum_2.f2_id
union
select top 2 count(id) as count1
,forum_2.f2_caption
,forum_2.f2_id
FROM online inner join forum_2 on online.boardid=forum_2.f2_id
group by forum_2.f2_caption
,forum_2.f2_id
order by forum_2.f2_id desc
) t
group by f2_caption
,forum_2.f2_id
ORDER BY forum_2.f2_id desc
解决方案 »
- 数据显示
- sql语句构造
- XPsp2,安装MSSQL2000个人版,快安装完时出现错误:创建一个或多个注册表项时出现错误。请参见 C:\WINXP\\\sqlstp.log 以了解详细情况。
- *********************请问关于SQLSERVER 2005 EXPRESS的问题**********************
- 据说是最好的分页存储过程,就是有点小问题,请大家一起来完善。
- 求sql
- 大家有谁知道用SQL语句怎么实现把日期格式成yymmddhhmmss的格式呀,谢谢啦
- 查询后字段类型发生变化,int(4)变成int(10),不思其解
- 复制库问题,领分来啦~~~
- 如何在外部运行批处理
- 请问这个Insert触发器该怎么写?
- 提个有点烦的问题。。。。。。。。。。。。请进来帮忙~!!~!~~!
group by f2_caption
,forum_2.f2_id
ORDER BY forum_2.f2_id desc那个 t 是什么意思啊?
异常详细信息: System.Data.SqlClient.SqlException: 列前缀 'forum_2' 与查询中所用的表名或别名不匹配。
异常详细信息: System.Data.SqlClient.SqlException: 列前缀 'forum_2' 与查询中所用的表名或别名不匹配。
,f2_caption
from
( select 0 as count1
,forum_2.f2_caption
,forum_2.f2_id
from online
inner join forum_2 on online.boardid<>forum_2.f2_id
union
select top 2 count(id) as count1
,forum_2.f2_caption
,forum_2.f2_id
FROM online inner join forum_2 on online.boardid=forum_2.f2_id
group by forum_2.f2_caption
,forum_2.f2_id
order by forum_2.f2_id desc
) t
group by f2_caption
,f2_id
ORDER BY f2_id desc
f2_caption
from
( select 0 as count1,
forum_2.f2_caption,
forum_2.f2_id
from online
inner join forum_2 on online.boardid<>forum_2.f2_id
union
select top 2 count(id) as count1,
forum_2.f2_caption,
forum_2.f2_id
FROM online inner join forum_2 on online.boardid=forum_2.f2_id
group by forum_2.f2_caption,
forum_2.f2_id
order by forum_2.f2_id desc )
group by f2_caption,
forum_2.f2_id
ORDER BY forum_2.f2_id desc