Apex Beginner Progress | ( Lessons)

Continue GO TO COURSE

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'

Exercises

#	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 198 users.

Apex Beginner

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (32 lessons)

01 SELECT & FROM

02 WHERE

03 ORDER BY

04 LIMIT

05 SELECT, FROM, WHERE, ORDER BY, LIMIT

06 AND & OR

07 COUNT()

08 SUM()

09 SUM() and GROUP BY

10 MAX()

11 MAX() & GROUP BY

12 MIN()

13 MIN() & GROUP BY

14 LIKE (A%)

15 AVG()

16 AVG & GROUP BY

17 IN() & NOT IN()

18 COUNT_DISTINCT()

19 INCLUDES()

20 EXCLUDES()

21 OFFSET

22 Comparison Operators

23 Parent-to-Child Query

24 Child-to-Parent Query

25 FIELDS()

26 Create a Query List

27 HAVING()

28 | Relative Date Filter Reference

29 | ActivityHistories

30 | Querying Scheduled Jobs

31 | Counting Contacts for Accounts

32 | Fetching Opportunities by Calendar Year

You need to complete all the quizzes before certification.

Lesson: 06 AND & OR

Query

Query Results

Video

Exercises

Apex Beginner

Lesson: 06 AND & OR

Query

Apex Beginner

Login to your account