求一考勤相关的SQl语句。。。

[spring11]

员工考勤记录表
ID cardid checktime
527 0000883229 2005-11-13 20:09:56
528 0000890452 2005-11-17 0:08:28
529 0000883229 2005-11-17 22:02:51
530 0000877133 2005-11-17 22:02:54
531 0000890452 2005-11-17 22:02:57
532 0000883229 2005-11-17 22:03:07
533 0000877133 2005-11-17 22:03:07
534 0000890452 2005-11-17 22:03:08

员工信息表
cardID NAME
0000883229 张三
0000877133 李四

要求：列出指定日期内，未参与考勤和只有一次考勤的员工（正常为2次考勤）

[spring11]

在邹老大的热心关注下，偶滴考勤系统一定会圆满滴完成的。
SQL菜鸟在各位的热心关怀下不断滴成长。。。放分！！

[zjcxc]

select * from 员工信息表 a
where (
select count(*) from 员工考勤记录表
where cardid =a.cardid
and checktime between '2005-11-13' and '2005-12-1'
)<2

[amtyuranus]

用having！！

select cardid,count(*) from where group by having

[bugchen888]

正常为两次是指在指定日期内每天两次，还是在指定日期内总共两次？

[brooks105]

select * from 员工信息表
where cardid in
(select cardid from 员工考勤记录表
where checktime between '2005-11-1' and '2005-12-31'
group by cardid
having count(1)<2)