HAVING Clause in SOQL (Salesforce Object Query Language)

Use WHERE Clause With HAVING Clause in SOQL Query

In Salesforce Object Query Language (SOQL), when we want to apply any condition in the query, we use the WHERE clause, and we can apply logic there. The HAVING clause is also used to apply conditions in the query, but we can use the HAVING clause in SOQL when we filter results that aggregate functions … Read more >>>

Create a For Loop to Iterate Through a SOQL Query in Salesforce

Salesforce SOQL query with for loop

In Salesforce SOQL, using a for loop within a for loop is a common approach to process and manipulate records efficiently. Using a for loop, we can iterate over the query results and apply logic directly to each record. In this Salesforce tutorial, I will explain how to create a for loop to iterate through … Read more >>>

OFFSET Clause in SOQL (Salesforce Object Query Language)

OFFSET Clause in SOQL (Salesforce Object Query Language)

As a Salesforce Developer, you want to retrieve records from the Salesforce object, and the results should display like each page of the portal displays 10 records, and we can navigate through pages to view more results using SOQL in Apex. For that, we have different clauses that have the functionality to fetch records in … Read more >>>

Salesforce SOQL Query RecordType

Count number of records assigned to record type in Salesforce SOQL

In Salesforce, RecordTypes allow us to group records of the same type for an object. It will enable the customization of page layouts, fields, required fields, and picklist values for different user profiles, as well as restrict field access for layouts and the creation of records.  For example, you can create record types to ensure … Read more >>>

How to Query SOQL NOT LIKE Operator in Salesforce

SOQL NOT LIKE Operator in Salesforce

In Salesforce, SOQL supports various operators for applying filters and conditions to query data, and one such operator is NOT LIKE. This operator is helpful in SOQL queries when you need to exclude records that match a specific pattern. In this Salesforce tutorial, I will explain how to use the NOT LIKE operator in Salesforce, and with the … Read more >>>

SOQL vs SQL Difference in Salesforce [Explained]

SOQL vs SQL Difference in Salesforce

SOQL stands for Salesforce Object Query Language, and SQL stands for Structured Query Language. These queries are used to retrieve data from the database and have some similarities. But they are customized for different environments. SOQL is used for Salesforce, and SQL is used for relational databases. In this Salesforce tutorial, we will learn about … Read more >>>

Salesforce SOQL Inner Join and Outer Join Relationships

Left Outer Join in Salesforce SOQL

In Salesforce, using SOQL, we manage data structures and relationships between objects. Executing the inner and outer join concepts is helpful in fetching data more efficiently and enhances our Salesforce applications’ functionality. In this Salesforce tutorial, I will explain inner joins and outer joins in Salesforce SOQL along with their syntax. Using real-time examples, we … Read more >>>

Salesforce SOQL Distinct Queries [How to Select DISTINCT values in SOQL?]

Count Distinct values in Salesforce SOQL

In other languages, a Distinct query returns only the unique values. This feature of the DISTINCT keyword is not supported in SOQL queries for finding unique and duplicate values. In this Salesforce SOQL tutorial, I will explain how to execute the alternate method for the DISTINCT keyword in SOQL to retrieve unique count values from … Read more >>>

Agentforce in Salesforce

DOWNLOAD FREE AGENTFORCE EBOOK

Start with AgentForce in Salesforce. Create your first agent and deploy to your Salesforce Org.

Salesforce flows complete guide

FREE SALESFORCE FLOW EBOOK

Learn how to work with flows in Salesforce with 5 different real time examples.