distict
slect distict name from table_user
group by
select name from table_user group by name
distict 和group by 的区别
distict 常和计数使用 count(distict name) group by常用来返回不同记录的值
使用group by 分组后,在select中可以选择分组字段,和非分组字段的函数值,如 max()、min()、sum、count()等
distict
slect distict name from table_user
group by
select name from table_user group by name
distict 和group by 的区别
distict 常和计数使用 count(distict name) group by常用来返回不同记录的值
使用group by 分组后,在select中可以选择分组字段,和非分组字段的函数值,如 max()、min()、sum、count()等