Book Image

Getting Started with SOQL

By : Magulan D
Book Image

Getting Started with SOQL

By: Magulan D

Overview of this book

<p>This practical guide will tell you everything you need to know about SOQL statements. You will learn the optimum way to write complex SOQL statements with this easy-to-understand guide. Beginning with basic SOQL statements, you will progress quickly onto more advanced statements, such as how to filter multiselect picklist values to escape sequences.</p> <p>This book will teach you how to sort records with more than one field, sorting with more than one field–one in ascending order and another field in descending order—and sorting null records in the first or in the last. You will learn about all the features provided while you are writing SOQL statements. This book will make you a SOQL expert by teaching you how to write SOQL statements in an optimized and effective way.</p>

Related Content you might be interested in

Current Title:

Small book image
Getting Started with SOQL
Magulan D
Apr, 2014 | 130 pages
No titles found
Table of Contents (14 chapters)
Getting Started with SOQL
Getting Started with SOQL
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Introduction to SOQL
Introduction to SOQL
What is SOQL?
Purpose of SOQL
SOQL syntax
Writing your first SOQL statement
Summary
2
Basic SOQL Statements
Basic SOQL Statements
The alias notation
The WHERE clause
The comparison operators
The IN operator
The logical operators
The ORDER BY clause
The INCLUDES and EXCLUDES operators
Summary
3
Advanced SOQL Statements
Advanced SOQL Statements
Relationship queries
Filtering multiselect picklist values
The escape sequences
The date formats
The date literals
Querying with the date fields
Sorting in both the ascending and descending orders
Using the GROUP BY ROLLUP clause
Using the FOR REFERENCE clause
Using the FOR VIEW clause
Using the GROUP BY CUBE clause
Using the OFFSET clause
Summary
4
Functions in SOQL
Functions in SOQL
Using the toLabel() method
Using the GROUP BY clause
Using the COUNT() method
Using the COUNT(Field_Name) method
Using the COUNT_DISTINCT() method
Using the MIN() method
Using the MAX() method
Using the SUM() method
Using the HAVING clause
Summary
5
Limitations and Best Practices
Limitations and Best Practices
Standards to be followed in SOQL
Best practices
Limitations in objects
Other limitations
Summary
6
Tools with Installation Guidelines
Tools with Installation Guidelines
Using the Force.com Explorer software
Workbench
Dataloader.io
The Apex Data Loader tool
Summary
Review Questions
Review Questions
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Index
Index

Using the HAVING clause

The HAVING clause is very similar to the WHERE clause. However, the only difference between the HAVING and WHERE clause is that the HAVING clause is used only with the aggregate functions.

The HAVING clause is used to specify the search condition in the GROUP BY clause or the aggregate functions. The HAVING clause limits the grouped records returned by a SOQL statement. However, the WHERE clause limits the records returned by a SOQL statement.

A HAVING clause in SOQL is used to specify that the SOQL SELECT statement should only return the records whose aggregate values meet the specified conditions.

A sample query is given as follows:

SELECT City__c, COUNT(Employee_Name__c) FROM Employee__c GROUP BY City__c HAVING COUNT(City__c) >= 1

The following screenshot shows us the output of the preceding query execution:

The output of the SOQL execution shows us the number of employees in each and every city whose number of records in each and every city is greater than one...

Previous Section
End of Section 10
Next Section