
▶MySQL SELECT DATE_FORMAT(SALES_DATE,'%Y-%m-%d') AS SALES_DATE ,PRODUCT_ID ,USER_ID ,SALES_AMOUNT FROM ONLINE_SALE WHERE SALES_DATE BETWEEN DATE_FORMAT('2022-03-01 00:00:00','%Y-%m-%d HH24:MI:SS') AND DATE_FORMAT('2022-03-31 23:59:59','%Y-%m-%d HH24:MI:SS') UNION ALL SELECT DATE_FORMAT(SALES_DATE,'%Y-%m-%d') AS SALES_DATE ,PRODUCT_ID ,NULL AS USER_ID ,SALES_AMOUNT FROM OFFLINE_SALE WHERE SALES_D..

▶MySQL SELECT COUNT(DISTINCT NAME) AS COUNT FROM ANIMAL_INS ▶Oracle SELECT COUNT(DISTINCT NAME) AS COUNT FROM ANIMAL_INS

▶MySQL SELECT COUNT(*) AS COUNT FROM ANIMAL_INS ▶Oracle SELECT COUNT(*) AS COUNT FROM ANIMAL_INS

▶MySQL SELECT MIN(DATETIME) AS 시간 FROM ANIMAL_INS ▶Oracle SELECT MIN(DATETIME) AS 시간 FROM ANIMAL_INS

▶MySQL SELECT MAX(DATETIME) AS 시간 FROM ANIMAL_INS ▶Oracle SELECT MAX(DATETIME) AS 시간 FROM ANIMAL_INS

▶MySQL SELECT MAX(PRICE) AS MAX_PRICE FROM PRODUCT ▶Oracle SELECT MAX(PRICE) AS MAX_PRICE FROM PRODUCT

▶MySQL SELECT * FROM FOOD_PRODUCT WHERE PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT) ▶Oracle SELECT * FROM FOOD_PRODUCT WHERE PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT) MySQL의 경우 LIMIT을 활용한 풀이도 가능합니다. Oracle은 ROWNUM과 FETCH를 활용해서도 가능합니다. ▶LIMIT SELECT * FROM FOOD_PRODUCT ORDER BY PRICE DESC LIMIT 1; ▶ROWNUM SELECT * FROM (SELECT * FROM FOOD_PRODUCT ORDER BY PRICE DESC) WHERE ROWNUM

▶MySQL SELECT RI.REST_ID ,RI.REST_NAME ,RI.FOOD_TYPE ,RI.FAVORITES ,RI.ADDRESS ,ROUND(AVG(RR.REVIEW_SCORE),2) AS SCORE FROM REST_INFO RI JOIN REST_REVIEW RR ON RI.REST_ID = RR.REST_ID WHERE RI.ADDRESS LIKE '서울%' GROUP BY RI.REST_ID,RI.REST_NAME,RI.FOOD_TYPE,RI.FAVORITES,RI.ADDRESS ORDER BY SCORE DESC,RI.FAVORITES DESC; ▶Oracle SELECT RI.REST_ID ,RI.REST_NAME ,RI.FOOD_TYPE ,RI.FAVORITES ,RI.ADDRE..

▶MySQL SELECT MCDP_CD AS "진료과코드" ,COUNT(*) AS "5월예약건수" FROM APPOINTMENT WHERE DATE_FORMAT(APNT_YMD,'%Y%m') = '202205' GROUP BY MCDP_CD ORDER BY COUNT(*),MCDP_CD ▶Oracle SELECT MCDP_CD AS "진료과코드" ,COUNT(*) AS "5월예약건수" FROM APPOINTMENT WHERE TO_CHAR(APNT_YMD,'YYYYMM') = '202205' GROUP BY MCDP_CD ORDER BY COUNT(*),MCDP_CD

▶MySQL SELECT II.INGREDIENT_TYPE ,SUM(FH.TOTAL_ORDER) AS TOTAL_ORDER FROM FIRST_HALF FH JOIN ICECREAM_INFO II ON FH.FLAVOR = II.FLAVOR GROUP BY II.INGREDIENT_TYPE ORDER BY TOTAL_ORDER ASC; ▶Oracle SELECT II.INGREDIENT_TYPE ,SUM(FH.TOTAL_ORDER) AS TOTAL_ORDER FROM FIRST_HALF FH ,ICECREAM_INFO II WHERE FH.FLAVOR = II.FLAVOR GROUP BY II.INGREDIENT_TYPE ORDER BY TOTAL_ORDER ASC;

▶MySQL SELECT NAME ,COUNT(NAME) AS COUNT FROM ANIMAL_INS GROUP BY NAME HAVING COUNT(NAME) >= 2 ORDER BY NAME; ▶Oracle SELECT NAME ,COUNT(NAME) AS COUNT FROM ANIMAL_INS GROUP BY NAME HAVING COUNT(NAME) >= 2 ORDER BY NAME; 집계 함수의 COUNT는 다음과 같이 서로 다른 결과 값을 출력합니다. COUNT(*) : NULL을 포함한 모든 행의 수 COUNT(컬럼) : NULL을 미포함한 모든 행의 수 COUNT(DISTINCT 컬럼) : 중복된 컬럼을 제외한 모든 행의 수

▶MySQL SELECT USER_ID , PRODUCT_ID FROM ONLINE_SALE GROUP BY USER_ID, PRODUCT_ID HAVING COUNT(*) > 1 ORDER BY USER_ID, PRODUCT_ID DESC; ▶Oracle SELECT USER_ID , PRODUCT_ID FROM ONLINE_SALE GROUP BY USER_ID, PRODUCT_ID HAVING COUNT(*) > 1 ORDER BY USER_ID, PRODUCT_ID DESC;