Connor Phillips

Data

Union Data with UNION and UNION ALL

| 5 min read

UNION and UNION ALL are set operators that combine results sets from multiple queries in order to aggregate and manipulate similar information.

Data

ORDER BY Clause

| 4 min read

ORDER BY is a SQL query clause that allows you to sort raw data by various combinations of data attributes.

Data

LIMIT / OFFSET Clauses

| 2 min read

LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.

Data

HAVING Clause

| 1 min read

The HAVING clause in SQL acts as a filtering mechanism similar to the WHERE clause, but for grouped columns and aggregate functions.

Data

GROUP BY Clause

| 1 min read

GROUP BY is the first non-relational layer SQL query clause. It creates unique data groupings and allows for aggregations to be used.

Data

WHERE Clause

| 2 min read

WHERE is a SQL query clause that allows you to filter raw data by various combinations of data attributes.

Data

FROM Clause

| 2 min read

The FROM clause opens up your search query to accessing data tables within your database.

Data

SELECT Clause

| 3 min read

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.

Data

Index Match

| 4 min read

Index-Match is a powerful spreadsheet lookup formula that is dynamic in nature and can handle searches regardless of a ranges directional data structure