Lesson: 06 AND & OR

The WHERE clause can contain multiple conditions that are grouped by using logical operators (AND, OR) and parentheses.

Query

SELECT AccountId, Status, Priority FROM Case WHERE Status ='Closed' AND Priority = 'High'

SELECT AccountId, Status, Priority FROM Case WHERE Priority = 'Medium' OR Priority = 'High'

#	Exercise
1	Opportunities within a Specific Amount Range
2	High Priority Case Management

Prev You need to login to have access to the quizzes. Next

Mastered by 189 users.

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (32 lessons)

You need to complete all the quizzes before certification.