SELECT count(1) AS cnt FROM ( SELECT * FROM table WHERE type = 'T001' AND empNo = 2017062201 ) t