Bird
Raised Fist0

Which SQL keyword is used to select rows where a column value is exactly 100?

easy🧠 Conceptual Q2 of Q15
C Sharp (C#) - LINQ Fundamentals

Which SQL keyword is used to select rows where a column value is exactly 100?

AWHERE column = 100
BWHERE column > 100
CWHERE column LIKE 100
DWHERE column != 100
Step-by-Step Solution
Solution:
  1. Step 1: Identify the condition for exact match

    To select rows where a column equals 100, use the equality operator =.
  2. Step 2: Check other options

    Greater than (>) selects values above 100, LIKE is for pattern matching, != means not equal.
  3. Final Answer:

    WHERE column = 100 -> Option A
  4. Quick Check:

    Exact match uses = operator [OK]
Quick Trick: Use = for exact matches in WHERE clause [OK]
Common Mistakes:
MISTAKES
  • Using LIKE for exact numbers
  • Using > instead of =
  • Using != for equality

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More C Sharp (C#) Quizzes