Skip to content

Instantly share code, notes, and snippets.

@nlpjoe

nlpjoe/main.md

Created July 8, 2020 07:20
Show Gist options
  • Save nlpjoe/ebf7bd17d92bf0081dbf887836ab722e to your computer and use it in GitHub Desktop.
Save nlpjoe/ebf7bd17d92bf0081dbf887836ab722e to your computer and use it in GitHub Desktop.
Download ZIP
[SQL语句如何统计一列中的值重复出现的次数,查询出的结果按次数的倒序排列？] #sql
Raw
main.md 
select 要统计的列名,count(*) from table
group by 要统计的列名
order by count(*) desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment