What is the SOQL WHERE Clause?<\/h2>\n\n\n\n
The SOQL WHERE Clause is the part of a query that filters records. It contains one or more conditions, such as Think of a school notice: “Students of Class 8, Section B, with attendance below 75%, must meet the principal.” Each part narrows the group. In the same way, a SOQL WHERE Clause narrows records.<\/p>\n\n\n\n Good filters keep queries fast, and they also keep code within limits. Here is why the SOQL WHERE Clause matters at Bright Path Tutors.<\/p>\n\n\n\n So clear filters give correct results and protect your limits.<\/p>\n\n\n\n Salesforce runs these clauses in a set order, so the SOQL WHERE Clause always runs before sorting. First, FROM picks the object. Next, the SOQL WHERE Clause filters the records. Then ORDER BY sorts the remaining rows. After that, OFFSET skips a number of rows. Finally, LIMIT caps how many rows come back.<\/p>\n\n\n\n The basic operators are LIKE matches text patterns, for example course names. The IN checks a value against a list, such as AND needs both conditions to be true, and OR needs at least one. Use brackets when you mix them, so the meaning is clear.<\/p>\n\n\n\n Use The table below lists the operators you will use most.<\/p>\n\n\n\n Paging means showing results page by page, for example 20 rows at a time. The table below compares two common approaches.<\/p>\n\n\n\n When to use which depends on the data size. So use OFFSET for small lists. Use keyset paging when users may scroll through thousands of records.<\/p>\n\n\n\n Let’s build filters for the Bright Path Tutors course catalogue. The website needs affordable online courses for beginners, sorted by start date, 10 per page.<\/p>\n\n\n\n First, the query keeps online courses at two levels. Then the bracketed OR keeps cheap courses or any “Basics” course. ORDER BY sorts by start date, and NULLS LAST puts undated courses at the end. LIMIT 10 returns only the first page.<\/p>\n\n\n\n The colon starts a bind variable, which inserts an Apex value into the query. Here offsetRows is 20, so OFFSET skips the first 20 rows and we get page 3. Sorting by start date and then name keeps the order stable between pages.<\/p>\n\n\n\n Here is an example of the debug log for these two blocks.<\/p>\n\n\n\n However, some values never use quotes. Booleans are Write a query that returns the 5 most expensive advanced courses that are not online. Hint: combine Level__c, Is_Online__c, ORDER BY Fee__c DESC and LIMIT 5.<\/p>\n\n\n\n Questions on the SOQL WHERE Clause and paging come up in nearly every developer interview. Here are the 20 most asked questions, with short answers.<\/p>\n\n\n\n Q1: What does the WHERE clause do in SOQL?<\/strong><\/p>\n\n\n\n It filters records, so the query returns only rows that match the conditions.<\/p>\n\n\n\n Q2: Are text comparisons in SOQL case sensitive?<\/strong><\/p>\n\n\n\n No. So text comparisons with = and LIKE match any case.<\/p>\n\n\n\n Q3: What wildcards does LIKE support?<\/strong><\/p>\n\n\n\n The % sign matches any number of characters, and _ matches exactly one character.<\/p>\n\n\n\n Q4: How do you check for blank values?<\/strong><\/p>\n\n\n\n Use = null for blank and != null for filled values, because SOQL does not support IS NULL.<\/p>\n\n\n\n Q5: How do you filter a multi-select picklist?<\/strong><\/p>\n\n\n\n Use INCLUDES or EXCLUDES, such as Topics__c INCLUDES (‘Apex’).<\/p>\n\n\n\n Q6: Do booleans and dates need quotes?<\/strong><\/p>\n\n\n\n No. For example, booleans are true or false, and dates use YYYY-MM-DD without quotes. Only text needs single quotes.<\/p>\n\n\n\n Q7: What does ORDER BY NULLS LAST do?<\/strong><\/p>\n\n\n\n It puts rows with blank values in the sort field at the end of the results.<\/p>\n\n\n\n Q8: How do you filter by a list of values from Apex?<\/strong><\/p>\n\n\n\n Use IN with a bind variable, such as WHERE Id IN :courseIds.<\/p>\n\n\n\n Q9: What is the maximum OFFSET value?<\/strong><\/p>\n\n\n\n The limit is 2,000, so a larger OFFSET throws an error.<\/p>\n\n\n\n Q10: Why should OFFSET always be used with ORDER BY?<\/strong><\/p>\n\n\n\n Without a fixed order, the database may return rows in a different order each time, so pages can overlap or skip records.<\/p>\n\n\n\n Q11: How do you get the newest five courses?<\/strong><\/p>\n\n\n\n For example, use ORDER BY CreatedDate DESC LIMIT 5.<\/p>\n\n\n\n Q12: What happens if you mix AND and OR without brackets?<\/strong><\/p>\n\n\n\n AND is evaluated before OR, which can give unexpected results. So brackets make the intent clear.<\/p>\n\n\n\n Q13: How do you sort by more than one field?<\/strong><\/p>\n\n\n\n List the fields after ORDER BY, separated by commas, such as ORDER BY Level__c ASC, Fee__c DESC.<\/p>\n\n\n\n Q14: How would you show page 4 of a 25-row list?<\/strong><\/p>\n\n\n\n For example, use LIMIT 25 OFFSET 75 with a stable ORDER BY.<\/p>\n\n\n\n Q15: What is keyset paging?<\/strong><\/p>\n\n\n\n It filters after the last value seen on the previous page, such as WHERE Name > :lastName ORDER BY Name. As a result, it stays fast on deep pages.<\/p>\n\n\n\n Q16: Which fields are indexed by default?<\/strong><\/p>\n\n\n\n For example, common ones include Id, Name, OwnerId, CreatedDate, SystemModstamp, lookup and master-detail fields, and external ID or unique fields.<\/p>\n\n\n\n Q17: Why can a LIKE filter starting with % be slow?<\/strong><\/p>\n\n\n\n A leading wildcard cannot use an index, so Salesforce may scan many more rows.<\/p>\n\n\n\n Q18: What is a selective query?<\/strong><\/p>\n\n\n\n It is a query whose filters use indexes and return a small share of the records. Because of this, selective queries stay fast on large objects.<\/p>\n\n\n\n Q19: Can you use a formula field in a WHERE clause?<\/strong><\/p>\n\n\n\n Often yes, but formula fields are usually not indexed, so filtering on them can be slow on large objects.<\/p>\n\n\n\n Q20: How do you avoid hitting the 50,000 row limit?<\/strong><\/p>\n\n\n\n First, use tight filters and LIMIT. Then process large data in Batch Apex, and avoid queries without a WHERE clause on big objects.<\/p>\n\n\n\nFee__c > 5000<\/code>. As a result, only records that match every rule come back. However, without a WHERE clause, the query returns every record the user can see.<\/p>\n\n\n\nWhy the SOQL WHERE Clause Matters<\/h2>\n\n\n\n
\n
How the SOQL WHERE Clause Works with ORDER BY, LIMIT and OFFSET<\/h2>\n\n\n\n
![\"SOQL](\"https:\/\/swapnilzambare.com\/blog\/wp-content\/uploads\/2026\/11\/soql-where-clause-order-by-limit-diagram-1-1024x640.png\")
Comparison Operators<\/h3>\n\n\n\n
=<\/code>, !=<\/code>, <<\/code>, <=<\/code>, ><\/code> and >=<\/code>. Text comparisons are not case sensitive, so Name = 'apex basics'<\/code> matches “Apex Basics”.<\/p>\n\n\n\nLIKE<\/h3>\n\n\n\n
%<\/code> sign matches any number of characters, and _<\/code> matches exactly one. For example, Name LIKE 'Apex%'<\/code> finds names that start with Apex.<\/p>\n\n\n\nIN and NOT IN<\/h3>\n\n\n\n
Level__c IN ('Beginner', 'Intermediate')<\/code>. In Apex, you can also pass a list or set with a bind variable.<\/p>\n\n\n\nAND, OR and NOT<\/h3>\n\n\n\n
Null Checks<\/h3>\n\n\n\n
Fee__c = null<\/code> to find blank values and Fee__c != null<\/code> to find filled ones. However, SOQL does not use IS NULL.<\/p>\n\n\n\nSOQL WHERE Clause Operators at a Glance<\/h2>\n\n\n\n
Operator<\/th> Example<\/th> Meaning<\/th><\/tr><\/thead> =<\/td> Level__c = ‘Beginner’<\/td> Equal to<\/td><\/tr> !=<\/td> Level__c != ‘Advanced’<\/td> Not equal to<\/td><\/tr> > and <<\/td> Fee__c > 5000<\/td> Greater or less than<\/td><\/tr> LIKE<\/td> Name LIKE ‘Apex%’<\/td> Text pattern<\/td><\/tr> IN<\/td> Level__c IN (‘Beginner’, ‘Intermediate’)<\/td> Matches any value in a list<\/td><\/tr> INCLUDES<\/td> Topics__c INCLUDES (‘Apex’)<\/td> Multi-select picklist contains a value<\/td><\/tr> = null<\/td> Start_Date__c = null<\/td> Field is blank<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n OFFSET Paging vs Keyset Paging<\/h2>\n\n\n\n
Feature<\/th> OFFSET paging<\/th> Keyset paging<\/th><\/tr><\/thead> How it works<\/td> Skip N rows with OFFSET<\/td> Filter after the last seen value<\/td><\/tr> Example<\/td> LIMIT 20 OFFSET 40<\/td> WHERE Name > :lastName LIMIT 20<\/td><\/tr> Maximum depth<\/td> OFFSET up to 2,000<\/td> No fixed depth limit<\/td><\/tr> Speed on deep pages<\/td> Slower<\/td> Stays fast<\/td><\/tr> Easy to jump to page 5<\/td> Yes<\/td> No, only next and previous<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n ![\"SOQL](\"https:\/\/swapnilzambare.com\/blog\/wp-content\/uploads\/2026\/11\/soql-where-clause-order-by-limit-diagram-2-1024x640.png\")
A Real SOQL WHERE Clause Example in Apex<\/h2>\n\n\n\n
Step 1: Combine Filters<\/h3>\n\n\n\n
List<Course__c> catalogue = [\n SELECT Id, Name, Fee__c, Level__c, Start_Date__c\n FROM Course__c\n WHERE Is_Online__c = true\n AND Level__c IN ('Beginner', 'Intermediate')\n AND (Fee__c < 5000 OR Name LIKE '%Basics%')\n ORDER BY Start_Date__c ASC NULLS LAST\n LIMIT 10\n];\nSystem.debug('Courses on page 1: ' + catalogue.size());<\/code><\/pre>\n\n\n\nStep 2: Add Paging with OFFSET<\/h3>\n\n\n\n
Integer pageSize = 10;\nInteger pageNumber = 3;\nInteger offsetRows = (pageNumber - 1) * pageSize;\n\nList<Course__c> page3 = [\n SELECT Id, Name, Start_Date__c\n FROM Course__c\n WHERE Is_Online__c = true\n ORDER BY Start_Date__c ASC, Name ASC\n LIMIT :pageSize\n OFFSET :offsetRows\n];\nSystem.debug('Page 3 first course: ' + (page3.isEmpty() ? 'none' : page3[0].Name));<\/code><\/pre>\n\n\n\nStep 3: Read the Output<\/h3>\n\n\n\n
USER_DEBUG [10]|DEBUG|Courses on page 1: 10\nUSER_DEBUG [13]|DEBUG|Page 3 first course: Data Loader Basics<\/code><\/pre>\n\n\n\nDates and Booleans in the SOQL WHERE Clause<\/h2>\n\n\n\n
true<\/code> or false<\/code>. Dates use the format 2026-09-15<\/code>, and date times use 2026-09-15T09:00:00Z<\/code>. In contrast, text values always need single quotes. In the next topics, you will also use date literals such as NEXT_N_DAYS:7<\/code>.<\/p>\n\n\n\nCommon Mistakes with the SOQL WHERE Clause<\/h2>\n\n\n\n
\n
Best Practices for the SOQL WHERE Clause<\/h2>\n\n\n\n
\n
Practice Task<\/h2>\n\n\n\n
Most Asked Interview Questions on the SOQL WHERE Clause<\/h2>\n\n\n\n
Basic Questions on the SOQL WHERE Clause<\/h3>\n\n\n\n
Code and Scenario Questions on the SOQL WHERE Clause<\/h3>\n\n\n\n
Advanced Questions on the SOQL WHERE Clause<\/h3>\n\n\n\n
Official Resources<\/h2>\n\n\n\n