[26] PostgreSQL – BETWEEN 연산자

[26] PostgreSQL – BETWEEN 연산자

예시 01:

여기에서는 샘플 데이터베이스의 "Payment" 테이블에 있는 BETWEEN 연산자를 사용하여 금액이 3 USD에서 5 USD 사이인 결제를 쿼리합니다.

SELECT
    customer_id,
    payment_id,
    amount
FROM
    payment
WHERE
    amount BETWEEN 3
AND 5;

결과 01:

예시 02:

여기서는 샘플 데이터베이스의 "Payment" 테이블에서 BETWEEN 연산자를 사용하여 지불 날짜가 2007-02-07과 2007-02-15 사이인 지불을 받기 위해 쿼리합니다.

SELECT
    customer_id,
    payment_id,
    amount,
 payment_date
FROM
    payment
WHERE
    payment_date BETWEEN '2007-02-07'
AND '2007-02-15';

결과 02: