sql 语句帮帮我着个错

来源：百度知道 编辑：UC知道 时间：2024/05/22 19:23:54
select month(shijian),sum(zonge) from [ticheng] where year(shijian)=2007 and day(shijian)>=1 and day(shijian)<=30 and username='n@163.com' group by month(shijian)

这个语句在sql查询分析器中~没错!

但是,在网页运行就有"在对应所需名称或序数的集合中，未找到项目。"错误~~~~~

改为
select month(shijian),sum(zonge) from [ticheng] where year(shijian)=2007 and day(shijian)>=1 and day(shijian)<=30 and username="n@163.com" group by month(shijian)

select month(shijian),sum(zonge) from [ticheng] where year(shijian)=2007 and (day(shijian)>=1 and day(shijian)<=30) and username=\'n@163.com\' group by month(shijian)
这样试试

select month(shijian),sum(zonge) from [ticheng] where shijian > '2007' and username = 'n@163.com' group by month(shijian)
对于时间的比较用这个非常简洁合理。

哦

select month(shijian) as shijian,sum(zonge) as zonge from [ticheng] ...