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

The ORDER BY clause

The ORDER BY clause in SOQL is used to sort the records retrieved in the ascending or descending order.

An ascending order sample query is given as follows:

SELECT Name, Amount FROM Opportunity ORDER BY Name ASC

The preceding query will retrieve all the Opportunity instances arranged in the ascending order of the name. The following screenshot is the output of the SOQL execution:

A descending order sample query is given as follows:

SELECT Name, Amount FROM Opportunity ORDER BY Name DESC

The preceding query will retrieve all the Opportunity instances arranged in the descending order of the name. The following screenshot is the output of the SOQL execution:

Note

Here, ASC means ascending order and DESC means descending order. By default, it will always be ascending order.

Previous Section
End of Section 7
Next Section