请教各位高手如下查询代码如何写---- select * from user where month(time)=9 order by time 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from user where month(time)='9' Select * from user where DATEPART(month,time) = 9 order by time desc "Select * from user where month(time)=9 order by time desc" select * from user where month(time)=9 select * from user where month([time])=9 order by [time] Select * from user where month(time)=9 order by time desc select * from [user] where month([time])=9 order by [time] 按我想肯定还有年份的限制吧select * from [user] where YEAR([time])='2003' AND month([time])=9 order by [time] 按我想肯定还有年份的限制吧select * from [user] where YEAR([time])=2003 AND month([time])=9 order by [time] 求写一个SQL语句 如何做通用的行列转换的存储过程 请教一个SQL写法 高分求“近义检索”功能思路!!! 别人有服务器数据库的密码,怎么才可以不让他到数据库里修改数据?? 【请教】为什么局域网内个别机器连不上SQL Server 2005 express SQL数据库还原出错 左外连接带查询条件时怎么保留null项 如何让自己的机器做服务器? 要在win95的客户端仿问win2000 server上的sql 2000server,要如何设置用户权限 一大堆弱智问题 请教如何判断一变量(如rs("data1"))的值是否为数字、日期或字符?代码如何写?
from user
where month(time)=9
select * from [user] where YEAR([time])='2003' AND month([time])=9
order by [time]
select * from [user] where YEAR([time])=2003 AND month([time])=9
order by [time]