SQL 문제 25 - Customer Placing the Largest Number of Orders LeetCode 586

SQL 문제 25 - Customer Placing the Largest Number of Orders LeetCode 586 Customer Placing the Largest Number of Orders 풀이 -- ORACLE SELECT T.CUSTOMER_NUMBER FROM ( SELECT CUSTOMER_NUMBER FROM ORDERS GROUP BY CUSTOMER_NUMBER ORDER BY COUNT(1) DESC ) T WHERE ROWNUM = 1; -- MYSQL SELECT CUSTOMER_NUMBER FROM ORDERS GROUP BY CUSTOMER_NUMBER ORDER BY COUNT(1) DESC LIMIT 1; -- MSSQL SELECT TOP 1 CUSTOMER_NUMBER FROM ORDERS GROUP BY CUSTOMER_NUMBER ORDER BY COUNT(1) DESC; * 출처 Level up your coding skills ...

원문링크 : SQL 문제 25 - Customer Placing the Largest Number of Orders LeetCode 586