Salesforce.com Object Query Language (SOQL) 示例

Salesforce 中的用户操作 打开按公司名称排序的供应商记录列表视图。
SOQL 查询 SELECT CompanyName__c,ContactName__c FROM Suppliers__x ORDER BY CompanyName__c ASC LIMIT 26

Salesforce 中的用户操作 点击查看按城市排序的供应商记录列表视图的第二页。
SOQL 查询 SELECT City__c,CompanyName__c FROM Suppliers__x ORDER BY City__c ASC OFFSET 25

Note: Unlike with SQL, the LIKE operator in SOQL performs a case-insensitive match.

NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed is 2000

上一篇:wfp(Application的运用)


下一篇:MapReduce编程:单词计数--《大数据基础教程》