SQL 문제 11 - Fix Names in a Table LeetCode 1667

SQL 문제 11 - Fix Names in a Table LeetCode 1667 Fix Names in a Table 풀이 -- ORACLE SELECT USER_ID , INITCAP(NAME) AS NAME FROM USERS ORDER BY USER_ID; -- MYSQL SELECT USER_ID , CONCAT(UPPER(LEFT(NAME,1)), LOWER(SUBSTRING(NAME,2))) AS NAME FROM USERS ORDER BY USER_ID; -- MSSQL SELECT USER_ID , UPPER(LEFT(NAME,1)) + LOWER(SUBSTRING(NAME,2,LEN(NAME))) AS NAME FROM USERS ORDER BY USER_ID; * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get p...

원문링크 : SQL 문제 11 - Fix Names in a Table LeetCode 1667