Category: SOQL

SOQL Joins Let’s look at what we can do with this data with some familiar JOIN patterns borrowed from SQL. This time, however, we will utilize them in SOQL and also use the power of relationship traversal in path...

Query child-to-parent relationships, which are often many-to-one. Specify these relationships directly in the SELECT, FROM, or WHERE clauses using the dot (.) operator. For example: SELECT Id, Name, Account.Name,...

which are almost always one-to-many. Specify these relationships using a subquery (enclosed in parentheses), where the initial member of the FROM clause in the subquery is related to the initial member of the outer...

CHAPTER 1 Introduction to SOQL and SOSL If you’ve built a custom UI for Salesforce, you can use the Salesforce Object Query Language (SOQL) and Salesforce Object Search Language (SOSL) APIs to search your organization’s...

The full form of SOQL is Salesforce Object Query Language. SOQL supports some features in SQL. SOQL is similar to SQL (Structures Query Language). By using SOQL in salesforce we fetch the data in force.com. What are the SOQL...

Select Id, Name From Account Where Id NOT IN (SELECT AccountId FROM Opportunity)

select id, name ,(select id from opportunities where StageName='Closed Won') from account

SELECT Id, Subject ,What.type, WhatID FROM Event Where What.Type IN('Account', 'Opportunity')