Skip to content

Instantly share code, notes, and snippets.

@enujo

enujo/mysqlorderby.sql

Created February 3, 2017 06:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save enujo/cc00cd4a0d7ce714ca45d245ffed3811 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save enujo/cc00cd4a0d7ce714ca45d245ffed3811 to your computer and use it in GitHub Desktop.
Download ZIP
오름차순 내림차순 정렬 mysql
Raw
mysqlorderby.sql
-- 오름차순 값이 적은 것부터 큰 순서대로
SELECT * FROM table_nm ORDER BY field_nm ASC;
-- 내림차순 값이 큰 것부터 작은 순서대로
SELECT * FROM table_nm ORDER BY field_nm DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment