Notice
Recent Posts
Recent Comments
Link
목록nulls late (1)
kimmgamjja
[Sql] Postgresql NULL 값 정렬 / ORDER BY NULLS LAST, NULLS FIRST
- NULLS FIRST : NULL 인 값이 먼저 보인다ex) SELECT * FROM TEST ORDER BY NAME NULLS FIRSTIDAGEGENDERNAME125여NULL217남 NULL 332여영희 - NULLS LAST : NULL 값을 나중에 보인다 ex) SELECT * FROM TEST ORDER BY NAME NULLS LAST IDAGEGENDERNAME332여영희 1 25 여 NULL 2 17 남 NULL https://www.postgresdba.com/bbs/board.php?bo_table=B10&wr_id=12 SQL > ORDER BY 절의 NULLS FIRST 과 NULL LAST - All About PostgreSQL" data-og-descr..
공부/Sql
2025. 2. 21. 15:37