【SQLSERVER】从一张考勤表tb_kq中找出员工每天的上班、下班打卡具体时间----2021.03.26

假如该公司存放的打卡时间不仅仅上下班两次打卡，还包含了中午外出吃饭打的卡，就是说每个人每天打卡次数大于2次；
考勤表相关字段如下：ID、NAME、NO、TIME

备注：建表和数据
create table tb_kq(id int,name varchar(10),no int,time datetime);
insert into tb_kq values(1,‘zhangsan’,1001,‘2020-01-01 08:34:40’);
insert into tb_kq values(2,‘lisi’,1002,‘2020-01-01 08:39:29’);
insert into tb_kq values(3,‘wangwu’,1003,‘2020-01-01 08:44:38’);
insert into tb_kq values(4,‘zhangsan’,1001,‘2020-01-01 18:24:18’);
insert into tb_kq values(5,‘lisi’,1002,‘2020-01-01 18:34:28’);
insert into tb_kq values(6,‘wangwu’,1003,‘2020-01-01 18:54:20’);
insert into tb_kq values(7,‘wangwu’,1003,‘2020-01-01 12:34:20’);
insert into tb_kq values(8,‘wangwu’,1003,‘2020-01-01 12:54:20’);

解决SQL:
select name,CONVERT(varchar(10),time,120),
min(time),
max(time)
from tb_kq
group by name,CONVERT(varchar(10),time,120)
备注：