Accessc查询具体日期
select * FROM user where Date between #2014-7-27 0:0:0# and #2014-7-27 23:59:59#;
Select * From user Where msg Like '*2*'
或者用Access中的Format函数来Format("Date","yyyy-MM-dd hh:mm:ss")
“Accessc查询具体日期” 的相关文章
SQL分页
select * from (select ROW_NUMBER() over(order by id desc) as row,* from Article) twhere t.row between 3 and 33with temp...
ACCESS和MSSQL-如何随机读取数据库记录
查询语句只要这样写,就可以随机取出记录了SQL="Select top 6 * from Dv_bbs1 where isbest = 1 and layer = 1 order by newID() desc"在AC...