Comparison Operators - BETWEEN

Giriş

Comparison Operators şöyle

< less than

> greater than

<= less than or equal to

>= greater than or equal to

= equal

<> or != not equal

BETWEEN

Örnek

Şöyle yaparız

select * from test a
inner join (
  select distinct order_id from test
  where status_update = 'Delivered'
) b on a.order_id = b.order_id
where status_date between '2020-01-01' and '2020-04-25'