天啊,这是access自己改我写好的语句
SELECT Max(entryexitfile.Time) AS Time之Max, Min(entryexitfile.Time) AS Time之Min
FROM entryexitfile
WHERE (((entryexitfile.Date)>#3/29/2005#))
GROUP BY entryexitfile.Date;不知道sql-server行不?我的原语句如下:
select max(time) from entryexitfile where date>#2005-03-29# group by date简直比微软的自然语言查询还牛啊!
SELECT Max(entryexitfile.Time) AS Time之Max, Min(entryexitfile.Time) AS Time之Min
FROM entryexitfile
WHERE (((entryexitfile.Date)>#3/29/2005#))
GROUP BY entryexitfile.Date;不知道sql-server行不?我的原语句如下:
select max(time) from entryexitfile where date>#2005-03-29# group by date简直比微软的自然语言查询还牛啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货