All Posts
Aliases are nicknames. They give us a shorthand way of...
LeetCode 1715. Write an SQL query to count the number...
The OR operator combines two Boolean expressions and returns true...
The LIMIT clause is used in the SELECT statement to...
The LIKE operator is used in a WHERE clause to...
To test whether a value is NULL or not, we...
The IN operator allows us to determine if a specified...
The BETWEEN operator selects values within a given range.
The AND operator is a logical operator that combines two...
The WHERE clause allows us to choose which rows are...
In order to remove duplicate rows, we use the DISTINCT...
LeetCode 1709. Write an SQL query that will, for each...
The ORDER BY clause is used to sort the result-set...
The SELECT statement allows us to read data from one...
A growing list of MySQL tutorials.
LeetCode 1384. Write an SQL query to report the Total...