MySql-語法練習2-查詢實作練習(使用邏輯運算子AND、OR)介於 BETWEEN

2021-02-24

BETWEEN 介於用法

請找出三科成績都大於80的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english>80 AND stu_chinese>80 AND stu_math>80

AND也可以使用&&符號代表

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english>80 && stu_chinese>80 && stu_math>80

請找出三科成績其中有一科大於80分的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english>80 OR stu_chinese>80 OR stu_math>80

OR 也可以使用II符號代表

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english>80 || stu_chinese>80 || stu_math>80

請找出英文成績 60 ~ 80分之間的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english >=60 AND stu_english<=80

請找出中文60~80之間並且數學60~70 之間的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_chinese >=60 AND stu_chinese<=80 AND stu_math >=60 AND stu_math<=70

BETWEEN 介於用法

請找出英文成績 60 ~ 80分之間的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_english BETWEEN 60 AND 80

請找出中文60~80之間並且數學60~70 之間的學生

SELECT stu_name ,stu_english ,stu_chinese ,stu_math FROM grade WHERE stu_chinese BETWEEN 60 AND 80 AND stu_math BETWEEN 60 AND 70

Yiru@Studio - 關於我 - 意如

Yiru@Studio