IN ALL FIELDS
RETURNING Account (Id, Name), Contact, Opportunity, Lead
Searches field values starting with the keyword 'test' in all fields in Account, Contact, Opportunity, Lead and displays the result.
IN Name FIELDS
RETURNING Lead(Name WHERE CreatedDate = THIS_FISCAL_QUARTER LIMIT 10)
Searches Test in Name field in Lead with the condition CreatedDate is this fiscal quarter.