Account table
|
Contact table
|
accessedAt
|
accessedAt
|
createdBy
|
bouncebackDate
|
currentStatus
|
currentStatus
|
Description
|
createdBy
|
folderId
|
Description
|
Permissions
|
folderId
|
scheduledFor
|
Permissions
|
sourceTemplateId
|
scheduledFor
|
updatedBy
|
sourceTemplateId
|
subscriptionDate
|
|
updatedBy
|
|
unsubscriptionDate
|
Query
|
Description
|
SELECT * FROM Contact WHERE Country='Switzerland'
|
There are more than 250 columns in the Contact table. To take advantage of bulk operations, constrain the SELECT statement to a set of less than 250 columns.
|
SELECT * FROM ContactList WHERE Region='East'
|
The ContactList table is not supported for bulk operations.
|
SELECT Id, C_Website FROM Account WHERE Id=17
|
This returns one row.
|
SELECT Id, C_Website FROM Contact WHERE Country='Switzerland' AND Region='EAST'
|
More than one criterion or comparison operator is used in the WHERE clause.
Tips:
![]() ![]() |