Skip to content

Instantly share code, notes, and snippets.

@noborus

noborus/あるカラムの文字頻度順

Last active August 29, 2015 13:57
Show Gist options
  • Save noborus/9458181 to your computer and use it in GitHub Desktop.
Save noborus/9458181 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
あるカラムの文字頻度順
SELECT COUNT (char) AS frequency, char
FROM
(SELECT substr (column_name, generate_series (1, LENGTH (column_name)), 1) AS char
FROM table_name) AS d
GROUP BY char
ORDER BY frequency DESC;
@noborus
Copy link
Author

noborus commented Mar 10, 2014

SELECT COUNT (char) AS frequency , char
FROM
(SELECT regexp_split_to_table(column_name, '') AS char
FROM table_name) AS w
GROUP BY char
ORDER BY frequency DESC;

こっちのほうが短い

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment