SELECT COUNT(DISTINCT id ,name) FROM ( SELECT 1 id ,2 name UNION ALL SELECT 2 id ,NULL name ) 结果是1条数据