Comparing object field values in the WHERE clause in Salesforce

SOQL does not currently support comparing same object field values in the WHERE clause, but there's simple workaround

First, create a formula field Flag__c on the SObject that performs the same comparison function as the desired WHERE clause.
IF (OwnerId == CreatedById, "true", "false")