Which clause can be used to specify a condition such as age greater than 18?

Which clause can be used to specify a condition such as age greater than 18?

• A. SELECT
• B. FROM
• C. WHERE
• D. ORDER BY

Answer: (C)

Filtering data with a condition in SQL is done using a clause that restricts which rows are returned. The clause used to specify something like age being greater than 18 is the WHERE clause. It evaluates a boolean expression for each row, and only rows that satisfy the condition are included in the results. For example: SELECT * FROM users WHERE age > 18; This returns only users whose age is above 18. You can build more complex checks with AND, OR, etc. The other clauses have different roles: SELECT decides which columns to show, FROM specifies the table, and ORDER BY arranges the results.

Filtering data with a condition in SQL is done using a clause that restricts which rows are returned. The clause used to specify something like age being greater than 18 is the WHERE clause. It evaluates a boolean expression for each row, and only rows that satisfy the condition are included in the results. For example: SELECT * FROM users WHERE age > 18; This returns only users whose age is above 18. You can build more complex checks with AND, OR, etc. The other clauses have different roles: SELECT decides which columns to show, FROM specifies the table, and ORDER BY arranges the results.