Oracle的BETWEEN在實(shí)際應(yīng)用中的案例

小樊
82
2024-07-19 10:21:42
欄目: 云計(jì)算

  1. 查詢某個(gè)時(shí)間段內(nèi)的銷售數(shù)據(jù)
SELECT *
FROM sales
WHERE sale_date BETWEEN '2021-01-01' AND '2021-12-31';
  1. 查詢某個(gè)價(jià)格范圍內(nèi)的產(chǎn)品信息
SELECT *
FROM products
WHERE price BETWEEN 10 AND 50;
  1. 查詢某個(gè)年齡段的客戶信息
SELECT *
FROM customers
WHERE age BETWEEN 18 AND 30;
  1. 查詢某個(gè)數(shù)量范圍內(nèi)的庫存信息
SELECT *
FROM inventory
WHERE quantity BETWEEN 100 AND 500;

0 踩