with checkIn as ( select '홍길동' inName, '20171016' inDate, '20171019' outDate, 1 inCnt from dual union all select '이길동' inName, '20171017' inDate, '20171018' outDate, 1 inCnt from dual union all select '김길동' inName, '20171018' inDate, '20171019' outDate, 1 inCnt from dual union all select '박길동' inName, '20171018' inDate, '20171019' outDate, 1 inCnt from dual union all select '안길동' inName, '20171018' inDate, '20171020' outDate, 1 inCnt from dual union all select '곽길동' inName, '20171018' inDate, '20171021' outDate, 1 inCnt from dual union all select '노길동' inName, '20171018' inDate, '20171022' outDate, 1 inCnt from dual union all select '손길동' inName, '20171019' inDate, '20171020' outDate, 1 inCnt from dual union all select '여길동' inName, '20171019' inDate, '20171021' outDate, 1 inCnt from dual union all select '조길동' inName, '20171020' inDate, '20171021' outDate, 1 inCnt from dual union all select '문길동' inName, '20171020' inDate, '20171022' outDate, 1 inCnt from dual ) select * from checkIn where inDate <= '20171018' and outDate > '20171018'
위 코드는 2017년 10월 18일 투숙객에 대한 리스트입니다.
조회하면 아래와 같이 출력됩니다.
홍길동 20171016 20171019 1
김길동 20171018 20171019 1
박길동 20171018 20171019 1
안길동 20171018 20171020 1
곽길동 20171018 20171021 1
노길동 20171018 20171022 1
질문) 20171017, 20171018 양일간(또는 기간정해서) 투숙한 리스트를 조회할려면 어떻게 해야되나여?