본문 바로가기

Filtering with WHERE

English
Filtering rows with WHERE

So far every query returned all the rows. Add a WHERE clause to keep only the rows that match a condition:

SELECT name, score FROM student WHERE score >= 80;

Only rows where the condition is true are returned.

WHERE score >= 80 keeps only the rows that pass the test: Mei, Sara and Lin

교재 자료

로그인 또는 계정 만들기

IGCSE, A-Level & AP