Where clause filtering in C Sharp (C#) - Step-by-Step Execution

Concept Flow - Where clause filtering

Start with full dataset

↓

Apply WHERE condition

↓

Check each row

↓

Include row

↓

Filtered result set

↓

End

Filtering data by checking each row against a condition and keeping only those that match.

Execution Sample

C Sharp (C#)

var filtered = people.Where(p => p.Age > 30);

Filters the list 'people' to include only those with Age greater than 30.

Execution Table

Step	Person Name	Person Age	Condition (Age > 30)	Include in Result
1	Alice	25	25 > 30 = False	No
2	Bob	35	35 > 30 = True	Yes
3	Charlie	30	30 > 30 = False	No
4	Diana	40	40 > 30 = True	Yes
5	Eve	28	28 > 30 = False	No

💡 All rows checked; only those with Age > 30 included.

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	After 5	Final
filtered count	0	0	1	1	2	2	2

Key Moments - 2 Insights

Why is Charlie not included even though his age is 30?

Because the condition is strictly greater than 30 (Age > 30). 30 is not greater than 30, so Charlie is excluded as shown in step 3 of the execution_table.

Does the WHERE clause change the original data?

No, it only filters and returns a new collection. The original 'people' list remains unchanged, as the WHERE clause just selects matching rows.

Visual Quiz - 3 Questions

Look at the execution_table, how many people are included in the filtered result?

A 4

B 3

C 2

D 1

💡 Hint

Check the 'Include in Result' column in the execution_table for rows marked 'Yes'.

At which step does the condition first evaluate to True?

A Step 2

B Step 1

C Step 3

D Step 4

💡 Hint

Look at the 'Condition (Age > 30)' column in the execution_table to find the first 'True'.

If the condition changed to Age >= 30, which person would be included additionally?

A Alice

B Charlie

C Eve

D No one else

💡 Hint

Check step 3 in execution_table where Age is exactly 30 and see if condition would be true with >=.

Concept Snapshot

WHERE clause filters rows based on a condition.
Syntax: collection.Where(row => condition).
Only rows meeting condition are included.
Original data stays unchanged.
Useful for selecting specific data from tables or lists.

Full Transcript

The WHERE clause filtering process starts with a full dataset. Each row is checked against a condition. If the condition is true, the row is included in the result; otherwise, it is excluded. For example, filtering people with Age > 30 checks each person's age. Only those older than 30 are kept. This does not change the original data but returns a new filtered collection. The execution table shows step-by-step how each person is tested and whether they are included. Key points include understanding strict vs inclusive conditions and that filtering does not modify original data.

Practice

1.

What does the WHERE clause do in a SQL query?

easy

A. Groups rows by a column

B. Filters rows based on a condition

C. Joins two tables together

D. Sorts the rows in ascending order

Solution

1. Step 1: Understand the purpose of WHERE clause

   The WHERE clause is used to select only rows that meet a specific condition.

2. Step 2: Compare with other SQL clauses

   Sorting is done by ORDER BY, joining by JOIN, grouping by GROUP BY, so WHERE is for filtering rows.

3. Final Answer:

   Filters rows based on a condition -> Option B

4. Quick Check:

   WHERE clause = filter rows [OK]

Hint: WHERE filters rows by condition, not sorting or joining [OK]

Common Mistakes:

• Confusing WHERE with ORDER BY
• Thinking WHERE joins tables
• Mixing WHERE with GROUP BY

2.

Which of the following is the correct syntax to filter rows where Age is greater than 30?

SELECT * FROM Users WHERE ___;

easy

A. Age > 30

B. Age = > 30

C. Age >> 30

D. Age >= 30

Solution

1. Step 1: Identify correct comparison operator

   The operator for 'greater than' is >, so 'Age > 30' is correct.

2. Step 2: Check other options for syntax errors

   'Age = > 30' and 'Age >> 30' are invalid syntax. 'Age >= 30' means 'greater or equal', not strictly greater.

3. Final Answer:

   Age > 30 -> Option A

4. Quick Check:

   Use > for greater than [OK]

Hint: Use > for greater than, >= for greater or equal [OK]

Common Mistakes:

• Using = > instead of >
• Using >> which is invalid
• Confusing > with >= operator

3.

Given the table Employees with columns Name and Salary, what rows will this query return?

SELECT Name FROM Employees WHERE Salary < 50000;

medium

A. Employees with salary less than 50000

B. Employees with salary greater than 50000

C. All employees regardless of salary

D. Employees with salary equal to 50000

Solution

1. Step 1: Understand the WHERE condition

   The condition Salary < 50000 means select rows where salary is less than 50000.

2. Step 2: Interpret the query result

   The query returns only the Name column for employees meeting that condition.

3. Final Answer:

   Employees with salary less than 50000 -> Option A

4. Quick Check:

   WHERE Salary < 50000 filters salaries below 50000 [OK]

Hint: Less than means <, so Salary < 50000 filters lower salaries [OK]

Common Mistakes:

• Confusing < with >
• Thinking it returns all employees
• Assuming it returns salary column too

4.

Identify the error in this query that tries to select users with age 18 or older:

SELECT * FROM Users WHERE Age => 18;

medium

A. WHERE clause cannot use numeric comparisons

B. Missing quotes around 18

C. The operator => is invalid; should be >= instead

D. SELECT * is not allowed with WHERE

Solution

1. Step 1: Check the comparison operator

   The operator => is not valid SQL syntax; the correct operator for 'greater or equal' is >=.

2. Step 2: Verify other parts of the query

   Numeric values like 18 do not need quotes, WHERE supports numeric comparisons, and SELECT * works with WHERE.

3. Final Answer:

   The operator => is invalid; should be >= instead -> Option C

4. Quick Check:

   Use >= for greater or equal, not => [OK]

Hint: Use >= for greater or equal, not => [OK]

Common Mistakes:

• Using => instead of >=
• Adding quotes around numbers
• Thinking WHERE can't compare numbers

5.

You want to select all products from a Products table where the Price is between 10 and 20 inclusive. Which WHERE clause is correct?

hard

A. Price BETWEEN 10 AND 20 EXCLUSIVE

B. Price > 10 AND Price < 20

C. Price >= 10 OR Price <= 20

D. Price >= 10 AND Price <= 20

Solution

1. Step 1: Understand inclusive range filtering

   Inclusive means including 10 and 20, so use >= and <= operators.

2. Step 2: Analyze each option

   Price > 10 AND Price < 20 excludes 10 and 20 (strictly greater and less). Price >= 10 OR Price <= 20 uses OR, which selects too many rows. Price BETWEEN 10 AND 20 EXCLUSIVE is invalid syntax.

3. Final Answer:

   Price >= 10 AND Price <= 20 -> Option D

4. Quick Check:

   Inclusive range uses >= and <= with AND [OK]

Hint: Use >= and <= with AND for inclusive ranges [OK]

Common Mistakes:

• Using > and < excludes boundary values
• Using OR instead of AND
• Trying invalid BETWEEN syntax