In this lesson we talk about what the HAVING clause means (adding a condition for the output of the aggregate function when the GROUP BY clause is used), and we also talk about how to update particular values in a row using the UPDATE clause.
In this tutorial we talk about how to join tables together. It is important to remember with joins to always set in the Where clause which field is equal in both tables, otherwise you will get a very big table.
In this tutorial we learn to put our rows into groups, count the number of rows in each group, and find the maximum, minimum, or average value of each group.
In this tutorial we learn to use functions such as DATE(), MAX(), INT() with arithmetical operators such as minus and divide.
In this video we learn to sort our results from a query using the order by clause.
In this lesson we talk about subqueries – using the result from one query as part of the condition of another query.
More SQL operators – Between – where we want to select rows with values between a certain range, or In, where we want the values to be in a set of specific values. We also talk about linking conditions together using brackets.
In this video we use the special operators AND, OR and LIKE in our select queries, to achieve some slightly more complicated queries.
In this video you learn about the select query – how to select specific rows / columns from a table. We also talk about using different comparison operators, such as larger than / smaller than or equal to.
So what you’ve created a table but you made a mistake in the data types of columns or you would like to add / delete columns? We show you how in this video.