SOQL Examples

1. Query all the Contacts which are not related to any Account

SELECT Id FROM Contact WHERE AccountId = null

2. Query all the Accounts which do not have any Contacts under them

SELECT Id FROM Account WHERE Id NOT IN (SELECT AccountId FROM Contact WHERE AccountId != null)

3. Query all the Opportunities with a Close Date in the future

SELECT Id FROM Opportunity WHERE CloseDate > TODAY