端数処理

SELECT 'Round' AS KW, Count(*) AS 件数 FROM tblCode WHERE コード LIKE '*Round*'
UNION ALL SELECT 'Int(',    Count(*) FROM tblCode WHERE コード LIKE '*Int(*'
UNION ALL SELECT 'Fix(',    Count(*) FROM tblCode WHERE コード LIKE '*Fix(*'
UNION ALL SELECT 'CInt(',   Count(*) FROM tblCode WHERE コード LIKE '*CInt(*'
UNION ALL SELECT 'CLng(',   Count(*) FROM tblCode WHERE コード LIKE '*CLng(*'
UNION ALL SELECT 'Format(', Count(*) FROM tblCode WHERE コード LIKE '*Format(*'
UNION ALL SELECT 'Floor',   Count(*) FROM tblCode WHERE コード LIKE '*Floor*'
UNION ALL SELECT 'Ceiling', Count(*) FROM tblCode WHERE コード LIKE '*Ceiling*';