56,679
社区成员
发帖
与我相关
我的任务
分享
SET @sql = '';
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'MAX(IF(DATE(CHECKTIME) = ''',
DATE(CHECKTIME),
''', CHECKTIME, 0)) AS ''',
DATE(CHECKTIME), ''''
)
) INTO @sql
FROM checkinout
WHERE DATE(CHECKTIME) BETWEEN '2016-06-01' AND '2016-06-05';
SET @sql = CONCAT('Select USERID, ', @sql,
' From checkinout
Group by USERID');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;