Which SQL clause is used to filter records based on more than one condition?
- AND
- FILTER
- OR
- WHERE
The OR operator in SQL is used to filter records based on more than one condition. It allows you to retrieve records that satisfy either of the specified conditions, providing flexibility in querying the database. The WHERE clause is used for a single condition, and AND combines conditions, but OR broadens the filter.
Loading...
Related Quiz
- Which technique in data mining is used for identifying unusual patterns or anomalies in data?
- In a script, numbers = [1, 2, 3]; new_numbers = [x * 10 for x in numbers]; print(new_numbers) is executed. What is the output?
- When merging data from multiple sources, what is a key consideration to ensure data consistency?
- What is the primary purpose of using a version control system like Git in software development?
- The process of arranging rows in a database table into a specific order is known as _______ in SQL.