ORDER BY Clause
ORDER BY is a SQL query clause that allows you to sort raw data by various combinations of data attributes.
LIMIT / OFFSET Clauses
LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.
HAVING Clause
The HAVING clause in SQL acts as a filtering mechanism similar to the WHERE clause, but for grouped columns and aggregate functions.
GROUP BY Clause
GROUP BY is the first non-relational layer SQL query clause. It creates unique data groupings and allows for aggregations to be used.
WHERE Clause
WHERE is a SQL query clause that allows you to filter raw data by various combinations of data attributes.
FROM Clause
The FROM clause opens up your search query to accessing data tables within your database.
SELECT Clause
SELECT is a foundational SQL clause that is mandatory to run queries. Learn more about SELECT with the start to my series on basic SQL queries.
Web 3.0 and the Promise of a Privacy-First Future
The evolution of the internet with web 3.0 and the privacy-first technologies leading new ways of identification
The Enjoyment of Working on Passion Projects
Coming to the realization that side projects need to be passion driven. Otherwise you run the risk of burn out.
The Losers in Apple's Privacy Battle - Small E-Commerce Businesses
The move by Apple to regulate third party data sharing and advertising cornered publishers like Facebook and Google and will accelerate the centralization of commerce within these platforms adversely impacting e-commerce businesses.
Connor Phillips
contact [at] connorphillips.com
Data leader with a decade of startup and agency experience helping B2C and B2B businesses with their mobile app and web-based products.
Currently, I lead the US Analytics team at the growth marketing agency, Twigeo, working with growth-focused clients ranging in industries from ride share to language learning.
📬 Subscribe to My Newsletter
Get the latest articles and exclusive content straight to your inbox.
- Previous Page
- Page 3 of 10
- Next Page