BestPromptFinder

SQL: Filter Rows by a Condition

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

Teach me how to filter rows in SQL with clear, runnable examples.

Inputs
- My table: [table name and columns], or use a simple example table
- Database: [e.g. PostgreSQL, MySQL, SQLite]

Cover, each with a one-line explanation and a runnable query:
1. WHERE with =, <>, <, >
2. AND / OR, and parentheses for precedence
3. IN and NOT IN
4. LIKE with % and _ (and ILIKE where relevant)
5. IS NULL / IS NOT NULL, and why = NULL doesn't work
6. BETWEEN for ranges and dates

End with three practice exercises on my table, and their answers hidden under a 'Solutions' heading.

Why this prompt

• AI-graded 90/100 for quality and structure
• Written for Gemini, GPT-5.6, Claude

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Education prompts