What is the function of the WHERE clause in MariaDB SQL queries?

What is the function of the WHERE clause in MariaDB SQL queries?

a) To limit the number of rows returned
b) To filter records based on a specific condition
c) To sort the result set
d) To join two tables

Answer:

b) To filter records based on a specific condition

Explanation:

The WHERE clause is used to filter records in a SQL query, returning only those rows that meet the specified condition.

Reference:

MariaDB Quiz – MCQ Questions and Answers

Scroll to Top