PostgreSQL數(shù)據(jù)過濾(七)

BETWEEN運算符允許您檢查值是否在值的范圍內(nèi)。

官網(wǎng)地址

聲明: 由于操作系統(tǒng), 版本更新等原因, 文章所列內(nèi)容不一定100%復現(xiàn), 還要以官方信息為準

https://www.postgresql.org/

PostgreSQL概述

PostgreSQL: 世界上最先進的開源關系數(shù)據(jù)庫。

PostgreSQL中BETWEEN 命令理論

• 如果該值大于或等于低值且小于或等于高值，則BETWEEN運算符返回true；否則，返回false。

• 語法示意

  value BETWEEN low AND high;
  

• 類似的語法

  value >= low AND value <= high
  value NOT BETWEEN low AND high
  value < low OR value > high
  

PostgreSQL中BETWEEN 命令實戰(zhàn)

數(shù)據(jù)庫樣例數(shù)據(jù)來源: https://blog.csdn.net/zwq56693/article/details/137473602

• 使用BETWEEN運算符檢索payment_id介于17510和17505之間的付款

  SELECT payment_id, amount 
  FROM payment 
  WHERE payment_id BETWEEN 17503 AND 17505 
  ORDER BY payment_id;
  

• 使用NOT BETWEEN運算符查找payment_id不在17510和17505之間的付款

  SELECT payment_id, amount 
  FROM payment 
  WHERE payment_id NOT BETWEEN 17503 AND 17505 
  ORDER BY payment_id;
  

• 使用BETWEEN運算符查找付款日期在2007-02-14和2007-02-20之間且金額超過10的付款

  SELECT payment_id, amount, payment_date 
  FROM payment 
  WHERE payment_date BETWEEN '2007-02-15' AND '2007-02-20' AND amount > 10 
  ORDER BY payment_date;
  

更新計劃

欲知后事如何, 請聽下回分解