webgyo/note.md

Created July 8, 2021 03:00

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/webgyo/b6d062c36281face49694e7e7dd4cadb.js"></script>
Save webgyo/b6d062c36281face49694e7e7dd4cadb to your computer and use it in GitHub Desktop.

SQLコマンドメモ #sql

Raw

SELECT word,SUM(search_count) AS total FROM search_words GROUP BY word;


SELECT word,SUM(search_count) AS total FROM search_words GROUP BY word ORDER BY total DESC;


SELECT word,SUM(search_count) AS total FROM search_words where word LIKE '%AAA%' GROUP BY word ORDER BY total DESC, word ASC;