WHERE Filtering Clause

Updated on 2023-11-03 GMT+08:00

View PDF

This statement is used to filter the query results using the WHERE clause.

1 2	SELECT [ALL \| DISTINCT] attr_expr_list FROM table_reference WHERE where_condition;

All is used to return repeated rows. By default, all repeated rows are returned. It is followed by asterisks (*) only. Otherwise, an error will occur.
DISTINCT is used to remove the repeated line from the result.
WHERE is used to filter out records that do not meet the condition and return records that meet the condition.

The to-be-queried table must exist.

To filter the records in which the scores are higher than 90 and lower than 95 in the student table, run the following statement:

1 2	SELECT * FROM student WHERE score > 90 AND score < 95;

Parent topic: Filtering

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel