Distinct Queries (learnsqlonline.org)
DISTINCT queries in SQL allow us to retrieve unique values from a column or a combination of columns in a table. By eliminating duplicates, we can obtain a clean and…
Continue readingSQL Tutorial
All SQL Tutorial content from my online portfolio
Aggregate Functions (learnsqlonline.org)
Aggregate functions in SQL enable us to perform calculations on sets of rows and return a single value as the result. These functions can summarize data, calculate statistics, and answer…
Continue readingThe HAVING Statement (learnsqlonline.org)
The HAVING statement is similar to the WHERE clause but operates on grouped data. It allows us to filter the results of a GROUP BY query based on conditions applied…
Continue readingWhat are the different types of SQL?
When starting any good SQL learning journey, you may quickly realise that once you’ve started to understand MySQL, all of a sudden there are 6 or 7 other types of…
Continue readingOrder By (learnsqlonline.org)
The ORDER BY clause in SQL is used to sort the result set based on specified columns. It allows us to arrange data in ascending or descending order. Sorting query…
Continue readingGroup By (learnsqlonline.org)
The GROUP BY clause in SQL is used to group rows from a table based on one or more columns. It enables us to aggregate data and perform calculations such…
Continue readingJoining Tables (learnsqlonline.org)
Table joins allow us to combine data from two or more tables based on a shared column or key. By leveraging table joins, we can create logical connections between tables,…
Continue readingDeleting Rows (learnsqlonline.org)
To delete specific rows from a table, you can utilize the WHERE clause in conjunction with the DELETE statement. The WHERE clause allows you to define conditions that must be…
Continue readingUpdating Rows (learnsqlonline.org)
Updating rows in a SQL database is a crucial task that allows you to modify existing data in a table. SQL provides a straightforward way to update rows using the…
Continue reading