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 ...
#
CustomerPlacingtheLargestNumberofOrders_LeetCode586
#
SQL
#
SQL_CustomerPlacingtheLargestNumberofOrders
#
SQL_CustomerPlacingtheLargestNumberofOrders_LeetCode586
#
SQL_LeetCode586
