SQL 문제 26 - Game Play Analysis I LeetCode 511

SQL 문제 26 - Game Play Analysis I LeetCode 511 Game Play Analysis I 풀이 -- ORACLE SELECT PLAYER_ID , TO_CHAR(MIN(EVENT_DATE),'YYYY-MM-DD') AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; -- MYSQL SELECT PLAYER_ID , MIN(EVENT_DATE) AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; -- MSSQL SELECT PLAYER_ID , CONVERT(CHAR(10),MIN(EVENT_DATE),120) AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge a...

원문링크 : SQL 문제 26 - Game Play Analysis I LeetCode 511