Salesforce Object Query Language | SOQL Basics

What is SOQL (Salesforce Object Query Language)?

Salesforce Object Query Language. It is used to retrieve data from Salesforce database according to the specified conditions and objects. Similar to all Apex code, SOQL is also case insensitive.

Use SOQL when you know which objects the data resides in, and you want to:

Retrieve data from a single object or from multiple objects that are related to one another.

Count the number of records which meet the specified criteria.

Sort results as part of the query.

Retrieve data from number, date, or checkbox fields.

A SOQL query is equivalent to a SELECT SQL statement and searches the org database.

Example:

Select name from account // standard object

Select name, Student_name from student__c // custom object

But we cannot use asterisk (*) in SOQL queries which we can use in sql.

Our Recent Blog

Key Roles & Responsibilities Of A Salesforce Administrator

19 Apr, 2022

Choosing a career as a Salesforce Administrator can be the best you can have because it will have a growing impact on the business.

How To Pass The Salesforce Developer Certification Exam?

17 Mar, 2022

Easy ways to crack salesforce developer program like learn basic coding, know prerequisites for salesforce developer certification, start practical exercises with trailhead.

Is Salesforce a Good Career?

01 Mar, 2022

Salesforce Developer Careers are on trending jobs across the globe. Start your career in Salesforce by taking Salesforce Developer Course, Admin Course.

Salesforce Career Choices In 2022 With Learning Path & Pay Scale

27 Jan, 2022

There's no denying that the Salesforce economy is thriving right now. IDC predicts that 4.2 million jobs are being created...

The 2022 Salary Guide for Salesforce Developers

25 Jan, 2022

Whenever a modern consumer needs more than simply a high-quality product or service, generating leads and converting them into loyal...

How To Pass The Salesforce Admin Certification Exam?

17 Jan, 2022

Salesforce is a critical component of the day-to-day operations of many businesses. The good news for Salesforce Admins is that...

Salary Guide Of Salesforce Consultant In 2022

13 Jan, 2022

Introduction: Before delving into the Consultancy part, let us understand what Salesforce is. Salesforce is the #1 CRM platform with...

Can I get a job by just learning Salesforce Admin?

30 Nov, 2021

In the 29th episode of the #AsktheHulk series Akarsh raised the question “Is there any opportunities for the Salesforce Admin?”

How the Salesforce Job Market is Growing

25 Nov, 2021

Introduction: Salesforce is considered to be the world’s most popular CRM platform while having at least a 20% market share,...

7 Best Salesforce Certifications In 2021

23 Nov, 2021

Introduction: Before moving towards the Best Salesforce Certification topic, let’s first understand about Salesforce, for those who are still unaware...

SOQL Basics (Salesforce Object Query Language)

What is SOQL (Salesforce Object Query Language)?

Our Recent Blog

Share This Post