Lesson: 05 SELECT, FROM, WHERE, ORDER BY, LIMIT

A query which can display 10 records FROM the Account object WHERE Name

Query

SELECT Name, Active__c , Industry
FROM Account 
WHERE (Active__c = 'Yes' AND Industry ='Energy')
ORDER BY Name
LIMIT 10

Note: We set LIMIT =10 but there are only 3 record in the results. The reason is because there are only 3 records satisfying the condition.

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

Mastered by 193 users.

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (32 lessons)

You need to complete all the quizzes before certification.