OR, AND and WHERE Clause:

Select Student_name from student__c where couse_opted__c = ‘Salesforce Admin’;

Select Student_name from student__c where couse_opted__c = ‘Salesforce Admin and App Builder’ OR couse_opted__c = ‘Salesforce Developer’;

Select Student_name from student__c where couse_opted__c = ‘Salesforce Admin and App Builder’ OR graduated__c = false;

Example:

public class soql

{

public static void main()

{

List<Account> accList = [Select Name, NumberOfEmployees from account];
for(integer i=0; i<accList.size(); i++)
{
System.debug(accList[i].numberOfEmployees);
}

// *** FOR EACH LOOP ***

for(Account a:acclist)
{
System.debug(‘Acc Name = ‘+a.Name+’NumOfEmp = ‘+a.numberOfEmployees);
}

}

}

Note: It is mandatory to mention the field in the SOQL query which you want to access in the Apex Code.

Note: Comparison of strings are case sensitive using ’=’ operator in soql.

Our Recent Blog

Key Roles & Responsibilities Of A Salesforce Administrator

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.

Read More

How To Pass The Salesforce Developer Certification Exam?

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.

Read More

Is Salesforce a Good Career?

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.

Read More

Salesforce Career Choices In 2022 With Learning Path & Pay Scale

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...

Read More

The 2022 Salary Guide for Salesforce Developers

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...

Read More

How To Pass The Salesforce Admin Certification Exam?

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...

Read More

Salary Guide Of Salesforce Consultant In 2022

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...

Read More

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?”

Read More

How the Salesforce Job Market is Growing

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,...

Read More

7 Best Salesforce Certifications In 2021

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...

Read More