Skip to content

Instantly share code, notes, and snippets.

View thebrettbarlow's full-sized avatar

Brett Barlow thebrettbarlow

10 followers · 1 following
View GitHub Profile
@thebrettbarlow
thebrettbarlow / SOQL_OpportunityTop5ByAmount.sql
Created March 20, 2019 03:41
SELECT Id, Name, Amount
FROM Opportunity
ORDER BY Amount DESC
LIMIT 5
@thebrettbarlow
thebrettbarlow / SOQL_OpportunityAmountDesc.sql
Created March 20, 2019 03:39
SELECT Id, Name, Amount
FROM Opportunity
ORDER BY Amount DESC NULLS LAST
@thebrettbarlow
thebrettbarlow / SOQL_ContactsByAccountNameFirstName.sql
Created March 20, 2019 03:36
SELECT Id, Account.Name, FirstName, LastName
FROM Contact
ORDER BY Account.Name, FirstName
@thebrettbarlow
thebrettbarlow / SOQL_AccountsAscByName.sql
Created March 20, 2019 03:34
SELECT Id, Name
FROM Account
ORDER BY Name ASC
@thebrettbarlow
thebrettbarlow / SOQL_AccountsInCaNyFl.sql
Created March 20, 2019 03:32
SELECT Id, Name, BillingState
FROM Account
WHERE BillingState IN ('CA', 'NY', 'FL')
@thebrettbarlow
thebrettbarlow / SOQL_LeadsThisWeekWeb.sql
Created March 20, 2019 03:31
SELECT Id, Company, LeadSource
FROM Lead
WHERE LeadSource = 'Web'
AND CreatedDate = THIS_WEEK
@thebrettbarlow
thebrettbarlow / SOQL_OpportunityAmountGt50k.sql
Created March 20, 2019 03:29
SELECT Id, Name, Amount
FROM Opportunity
WHERE Amount > 50000
@thebrettbarlow
thebrettbarlow / SOQL DateTime with Date (clean way).sql
Created February 27, 2019 04:42
SELECT Id, Name
FROM Lead
WHERE DAY_ONLY(CreatedDate) = 2019-02-27
@thebrettbarlow
thebrettbarlow / SOQL DateTime with Date (ugly way).sql
Created February 27, 2019 04:34
SELECT Id, Name
FROM Lead
WHERE CreatedDate >= 2019-02-27T00:00:00Z
AND CreatedDate < 2019-02-28T00:00:00Z
@thebrettbarlow
thebrettbarlow / NOT LIKE (Filter out B or C).sql
Created February 27, 2019 03:46
SELECT Id, FirstName, LastName, Email, Phone
FROM Contact
WHERE NOT (
FirstName LIKE 'B%' OR
FirstName LIKE 'C%'
)