Apex Beginner Progress | ( Lessons)

Lesson: 22 Comparison Operators

Query

= equal:

SELECT Name, StageName FROM Opportunity WHERE StageName = 'Prospecting'

!= Not Equal:

SELECT Name, StageName FROM Opportunity WHERE StageName != 'Prospecting'

> More Than;

SELECT Name, Amount FROM Opportunity WHERE Amount > 100000 ORDER BY Amount

< Less Than:

SELECT Name, Amount FROM Opportunity WHERE Amount < 100000 ORDER BY Amount DESC

>= More Than and Equal:

SELECT Name, Amount FROM Opportunity WHERE Amount >= 100000 ORDER BY Amount DESC

<= Less Than and Equal:

SELECT Name, Amount FROM Opportunity WHERE Amount <= 100000 ORDER BY Amount DESC

#	Exercise
1	Opportunity Tracking for Sales Forecasting
2	Lead Conversion Tracking
3	High-Value Opportunity Tracking

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

Mastered by 161 users.

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (33 lessons)

You need to complete all the quizzes before certification.