๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

order by ์ ˆ1

[ORACLE] ORDER BY ๋ช…๋ น์–ด ๊ธฐ๋ณธ ์‚ฌ์šฉ :: ๋งˆ์ด์ž๋ชฝ ORACLE ORDER BY ๋ช…๋ น์–ด ๊ธฐ๋ณธ ์‚ฌ์šฉ์ด์ „ ๊ธ€์—์„œ SELECT์™€ WHERE์ ˆ์„ ์‚ฌ์šฉํ•˜์—ฌ ์›ํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ๊ฒ€์ƒ‰ํ–ˆ๋‹ค๋ฉด, ์ด๋ฒˆ ๊ธ€์—์„œ๋Š” ORDER BY ์ ˆ์„ ์ด์šฉํ•˜์—ฌ ์ฐพ์•„์˜จ ๋ฐ์ดํ„ฐ๋ฅผ ํŠน์ • ํ•„๋“œ๋กœ ์ •๋ ฌํ•˜๋Š” ๋ฐฉ๋ฒ•์„ ํ•ด๋ณผ๊ฒƒ์ด๋‹ค. ํ•ด๋‹น๊ธ€์—์„œ๋Š” Oracle 11g ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜๊ณ  HR๊ณ„์ •์˜ ๊ธฐ๋ณธ ํ…Œ์ด๋ธ”์„ ์‚ฌ์šฉํ•˜์—ฌ ์‹ค์Šตํ–ˆ์Šต๋‹ˆ๋‹ค. ORDER BY ํ…์ŠคํŠธํ…์ŠคํŠธ ํ˜•ํƒœ๋กœ ORDER BY์ ˆ์„ ์‚ฌ์šฉํ–ˆ์„๋•Œ๋Š” abc, ๊ฐ€๋‚˜๋‹ค ์ˆœ์œผ๋กœ ์ •๋ ฌ๋˜๊ณ  ๋‚ด๋ฆผ์ฐจ์ˆœ(DESC), ์˜ค๋ฆ„์ฐจ์ˆœ(ASC) ๋ช…๋ น์„ ํ•˜์ง€ ์•Š์œผ๋ฉด ์˜ค๋ฆ„์ฐจ์ˆœ์ด ๊ธฐ๋ณธ์ด๋‹ค.๋ช…๋ น : SELECT [ํ•„๋“œ1], [ํ•„๋“œ2], ... FROM [ํ…Œ์ด๋ธ”] ORDER BY [ํ•„๋“œ1] ์ƒ๋žต/ASC/DESC; QUERYEMPLOYEES ํ…Œ์ด๋ธ”๋ฅผ LAST_NAME ๋‚ด๋ฆผ์ฐจ์ˆœ(DESC)์œผ๋กœ ์กฐํšŒํ•œ๋‹ค.1.. 2019. 9. 8.