1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| -- 코드를 입력하세요
SELECT A.FOOD_TYPE
,A.REST_ID
,A.REST_NAME
,A.FAVORITES
FROM (SELECT FOOD_TYPE
,REST_ID
,REST_NAME
,FAVORITES
,RANK()OVER(PARTITION BY FOOD_TYPE ORDER BY FAVORITES DESC) AS RANKK
FROM REST_INFO) AS A
WHERE A.RANKK = 1
GROUP
BY A. FOOD_TYPE
ORDER
BY A.FOOD_TYPE DESC;
|