Dev.to

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data with WHERE The WHERE clause filters rows that meet specific conditions. Example: SELECT * FROM users WHERE Age > 25; Combining Filters with AND, OR, and NOT AND: Filters rows that meet all conditions. SELECT * FROM users WHERE Age > 25 AND City = 'New York'; OR: Filters rows that meet at least one condition. SELECT * FROM users WHERE Age > 25 OR City = 'New York'; NOT: Excludes rows that meet the condition. SELECT * FROM users WHERE NOT Age

Apr 16, 2025 - 20:34
 0
Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data with WHERE

The WHERE clause filters rows that meet specific conditions.

Example:

SELECT * FROM users WHERE Age > 25;

Combining Filters with AND, OR, and NOT

  • AND: Filters rows that meet all conditions. 
SELECT * FROM users WHERE Age > 25 AND City = 'New York';
  • OR: Filters rows that meet at least one condition. 
SELECT * FROM users WHERE Age > 25 OR City = 'New York';
  • NOT: Excludes rows that meet the condition. 
SELECT * FROM users WHERE NOT Age < 25;

Challenge: Write Complex Filters

Retrieve all orders placed in 2023 by users from New York or San Francisco.

Read More

Tags:

Previous Article

Manus AI: The Future of Autonomous Artificial Intelligence

Next Article

บทความ "K-Means Clustering: Clustering Unsupervised Machine Learning"

Related Posts

165/365 | ¥10M Job Challenge - A Fast-Moving World

165/365 | ¥10M Job Challenge - A Fast-Moving World

Mar 27, 2025  0

Building an LLM Agent with N8N and Open-WebUI

Building an LLM Agent with N8N and Open-WebUI

Mar 23, 2025  0

Lessons Learned from Implementing Mutual TLS (mTLS) in a Secure System

Lessons Learned from Implementing Mutual TLS (mTLS) in ...

Feb 23, 2025  0