查询sql 命令:
SELECT
MachineName,
EqpIP,
ActStsMach,
ActCntCyc,
ActTimCyc,
ActTimFill1,
EventTime
FROM
API_MoldingParamData x
WHERE
CreateTime = (
SELECT
MAX (CreateTime)
FROM
API_MoldingParamData y
WHERE
x.MachineName = y.MachineName
)
AND MachineName IN (
'C4-1F-Molding-C08',
'C4-1F-Molding-C09',
'C4-1F-Molding-C10',
'C4-1F-Molding-C11',
'C4-1F-Molding-C12',
'C4-1F-Molding-D07',
'C4-1F-Molding-D08',
'C4-1F-Molding-D09'
)
ORDER BY
MachineName;
结果如图