例:
Id Name Address ============================== 1 MyName MyAddress 2 MySecondName Address2
就像是:
select count(distinct id,name,address) from mytable
SELECT Count(*) FROM ( SELECT DISTINCT id,address FROM your_table ) As distinctified