강의로 돌아가기
xmas6904201@gmail.com

ORACLE

SELECT
historyid ,
car
id ,
tochar(startdate,'YYYY-MM-DD') startdate ,
to
char(enddate ,'YYYY-MM-DD') enddate ,
(
CASE
WHEN tonumber(tochar(enddate - startdate + 1)) >= 30 THEN '장기 대여'
ELSE '단기 대여'
END
) AS RENTTYPE
FROM
CAR
RENTALCOMPANYRENTALHISTORY
WHERE
to
char(startdate, 'YYYY-MM') = '2022-09'
ORDER BY
history
id desc

작성중인 코드―solution.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SELECT 
    history_id ,
    car_id ,
    to_char(start_date,'YYYY-MM-DD') start_date ,
    to_char(end_date ,'YYYY-MM-DD') end_date ,
    (
    CASE
        WHEN to_number(to_char(end_date - start_date + 1)) >= 30 THEN '장기 대여'
        ELSE '단기 대여'
    END
    ) AS RENT_TYPE
FROM 
    CAR_RENTAL_COMPANY_RENTAL_HISTORY 
WHERE 
    to_char(start_date, 'YYYY-MM') = '2022-09'
ORDER BY 
    history_id desc
0 개의 답변
답변 쓰기
This input form supports markdown syntax. Please refer to 마크다운 가이드.