Apex Beginner Progress | ( Lessons)

Lesson: 17 IN() & NOT IN()

Query

SELECT Name, StageName  FROM Opportunity WHERE StageName 
IN('Prospecting', 'Closed Won', 'Value Proposition')

SELECT Id, Name FROM Account WHERE Id IN (SELECT AccountId FROM Contact)

SELECT Id, Name FROM Account WHERE Id NOT IN (SELECT AccountId FROM Contact)

#	Exercise
1	Account-Contact Verification
2	Accounts with Associated Contacts
3	Accounts with Open Cases and Unclosed Opportunities
4	Accounts with Related Cases
5	Identify Accounts with Contacts and No Closed Opportunities or Cases

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

Mastered by 169 users.

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (33 lessons)

You need to complete all the quizzes before certification.