Summary of Limit + Aliasing in MySQL | MySQL Beginner Series
The video focuses on the concepts of limit and aliasing in MySQL, explaining how to use them in SQL queries to filter results and rename columns. The methodology includes using the limit keyword, combining it with order by, adding an offset parameter, and using the as keyword for aliasing.
Notable Quotes
—
00:27
— « it can be combined with order by to actually be really powerful.
»
—
00:31
— « for example let's say we wanted to take the three oldest employees.
»
—
01:50
— « aliasing is just a way to change the name of the column.
»
—
02:41
— « we can actually change the name of this column and subsequently use it throughout our query with that aliased name.
»
—
03:29
— « that is how we can use limit and aliasing in SQL. »