5.10SOQL basics

Basic syntax:

SELECT Id, Name
FROM Account

Looks familiar.

Filter:

SELECT Id, Name
FROM Account
WHERE Industry = 'Technology'

Sort:

SELECT Id, Name
FROM Account
WHERE Industry = 'Technology'
ORDER BY Name

Limit:

SELECT Id, Name
FROM Account
LIMIT 100

SOQL supports the familiar SELECT, FROM, WHERE, ORDER BY, and LIMIT concepts.