USE E_TestData
SELECT E.EmployeeName AS 姓名,COUNT(*) AS 总数 FROM TDATA AS T
INNER JOIN Employee AS E ON E.Job_Number=T.JobNumber
WHERE Date_Time LIKE '2018/01%' AND Line='2F-TEST-L01'--/02/05%' AND Model='MS-B85-BTC'
GROUP BY E.EmployeeName ORDER BY count(*)DESC
select * from TDATA WHERE Date_Time LIKE '2018/02/06%' AND Model='MS-B85-BTC' ORDER BY Date_Time DESC
USE E_TestData
SELECT E.EmployeeName AS 姓名,COUNT(*) AS 总数 FROM TDATA AS T
INNER JOIN Employee AS E ON E.Job_Number=T.JobNumber
WHERE Date_Time LIKE '2018/02/06%' AND Model='MS-B85-BTC'
GROUP BY E.EmployeeName ORDER BY count(*)DESC
SELECT E.EmployeeName AS 姓名,COUNT(*) AS 总数 FROM TDATA AS T
INNER JOIN Employee AS E ON E.Job_Number=T.JobNumber
WHERE Date_Time LIKE '2018/01%' AND Line='2F-TEST-L01'--/02/05%' AND Model='MS-B85-BTC'
GROUP BY E.EmployeeName ORDER BY count(*)DESC
select * from TDATA WHERE Date_Time LIKE '2018/02/06%' AND Model='MS-B85-BTC' ORDER BY Date_Time DESC
USE E_TestData
SELECT E.EmployeeName AS 姓名,COUNT(*) AS 总数 FROM TDATA AS T
INNER JOIN Employee AS E ON E.Job_Number=T.JobNumber
WHERE Date_Time LIKE '2018/02/06%' AND Model='MS-B85-BTC'
GROUP BY E.EmployeeName ORDER BY count(*)DESC