✏️ Explanatory Question
Select [FindOptions] [FieldList] from [Table] [Options] [OrderByClause] [WhereClause] [JoinClause]
Role of FindOptions in a select statement: FindOptions can control how data is retrieved, such as firstOnly for fetching the first matching record. Example:
select firstOnly CustTable where CustTable.AccountNum == '4000';
The Find options parameters give additional options for pulling data. For example, crossCompany pulls data across legal entities, firstOnly pulls only the first record, firstOnly10 only fetches the first ten records, and forUpdate selects the data with a lock.