distinct group by

 

select num from test_test group by num; 比 select distinct（num） from test_test;  效率高


 

select count（distinct （num）from test_test