'发贴统计
select poster as 用户名,count(*) as 发贴次数,sum(len(message)) as 发贴字数 From dnt_posts1 where fid = 7 and layer = 0 and postdatetime >= #02/01/2010# group by poster '回贴统计
select poster as 用户名,count(*) as 回贴次数,sum(len(message)) as 回贴字数 From dnt_posts1 where fid = 7 and layer = 1 and postdatetime >= #02/01/2010# group by poster
怎么能将其合并成一条: “用户名,发贴次数,发贴字数,回贴次数,回贴字数”。 数据库是ACCESS。
select poster as 用户名,count(*) as 发贴次数,sum(len(message)) as 发贴字数 From dnt_posts1 where fid = 7 and layer = 0 and postdatetime >= #02/01/2010# group by poster '回贴统计
select poster as 用户名,count(*) as 回贴次数,sum(len(message)) as 回贴字数 From dnt_posts1 where fid = 7 and layer = 1 and postdatetime >= #02/01/2010# group by poster
怎么能将其合并成一条: “用户名,发贴次数,发贴字数,回贴次数,回贴字数”。 数据库是ACCESS。
解决方案 »
- 请教一个C#调用返回多列的存储过程的问题
- RegistrationException 异常
- 关于.NET(c#)读取EXCEL数据的问题
- 帮忙解决农历表的问题!
- 图像打印问题:调用DrawImage(aImg, dRect)后,打印要等待将近10分钟,而调用DrawString()的速度勉强接受;为什么?
- C#是否支持参数的引用传递
- 字段列名无效
- 下面两个是什么问题,应该怎样解决?
- 【在线等!】调用VC开发的DLL的问题
- c#初学者,想把这段代码(VB中全文检索的部分)转换成C#的,可是高了2天没有成功,大伙帮忙看一看,100分求助!
- VS2005 C# GridView中的编辑问题
- 急寻~谁有将BMP 真彩图转化为单色二值化的TIF (CCIT4)的代码~~~
sum(iif(layer = 0,1,0)) as 发贴次数,sum(iif(layer = 0,len(message),0)) as 发贴字数
sum(iif(layer = 1,1,0)) as 回贴次数,sum(iif(layer = 1,len(message),0)) as 回贴字数
From dnt_posts1 where fid = 7
and postdatetime >= #02/01/2010#
group by poster