Created
February 3, 2017 06:10
-
-
Save enujo/cc00cd4a0d7ce714ca45d245ffed3811 to your computer and use it in GitHub Desktop.
오름차순 내림차순 정렬 mysql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 오름차순 값이 적은 것부터 큰 순서대로 | |
| 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