1667. Fix Names in a Table oracle

https://leetcode.com/problems/fix-names-in-a-table/

Fix Names in a Table - LeetCode

 

select user_id, initcap(name) as name from users order by user_id;

SQL 문법 참고 : https://1day1code.tistory.com/entry/SQL-%EB%AC%B8%EC%9E%90-%ED%95%A8%EC%88%98-LOWER-UPPER-INITCAP

[SQL] 문자 함수 (LOWER/ UPPER/ INITCAP/ CONCAT/ SUBSTR/ LENGTH/ INSTR/ LPAD/ RPAD/ REPLACE/ TRIM)

MySQL에는 initcap이란 문법이 없길래 어떻게 하나 찾아봤다. 

select user_id, concat(upper(left(name, 1)), lower(right(name, length(name) - 1))) as name from Users group by 1 order by 1;

 

출처 :

https://medium.com/jen-li-chen-in-data-science/leetcode-sql-9aa7dab0f56b

Leetcode SQL