查询的问题-如何差某个月的记录?! Select * From TableNameWhere Datepart(mm, Field1)= 4 //查出4月份的数据~~~~~~~~~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 使用sql server的日期函数,year,month select * from yourtable where DATEPART ( mm, datetimefield ) = month or select * from yourtable where MONTH(datetimefield ) = month or select * from yourtable where MONTH(datetimefield ) = month select * from yourtable where mm >= monthdate AND mm <= monthdate Datepart(mm, Field1)= 4 MONTH(datetimefield ) = month都会把不同年的数据放在一起.最好:select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'这样效率也高些 Datepart(mm, Field1)= 4 MONTH(datetimefield ) = month都会把不同年的数据放在一起.最好:select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'这样效率也高些 Datepart(mm, Field1)= 4 MONTH(datetimefield ) = month都会把不同年的数据放在一起.最好:select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'这样效率也高些 有month函数啊!select * from yourtable where month(field)=5 @人才网站数据库设计 两张表合并输出不重复的手机号码 求最多连续编号 求助,简单问题 远程访问 网站、数据库问题 同时执行两条语句用什么间隔符 怎么能知道网吧主机的内部IP 数据库和用户名和主机密码啊? 如何批量更新一个表中某一字段的值为另一表某一字段的值 一个有关当前记录号的问题。(类似功能) 如何将sql server 2000的 数据转到 sql server 7.0 中 请问:select top 10 * from A1 我想取的下10条记录怎么办? 谢谢!!!
select * from yourtable where MONTH(datetimefield ) = month
select * from yourtable where MONTH(datetimefield ) = month
MONTH(datetimefield ) = month
都会把不同年的数据放在一起.最好:
select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'
这样效率也高些
MONTH(datetimefield ) = month
都会把不同年的数据放在一起.最好:
select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'
这样效率也高些
MONTH(datetimefield ) = month
都会把不同年的数据放在一起.最好:
select * from yourtable where datetimefield>= '2002-4-1' AND datetimefield <'2002-5-1'
这样效率也高些
select * from yourtable where month(field)=5