The following clause will return the total number of newly hired employees of a company from Aug, 2005 to April, 2006.
select count(*) as total from employees
where
(([hiredate]>CAST('2005-Aug' AS datetime) and ([hiredate]<CAST('2006-Apr' AS datetime))
posted on 2006-04-13 02:35 Gravitonium 阅读(206) 评论(0) 收藏 举报
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。