Sign in Subscribe

Xavier Geerinck

SQL - Part 2 - Aggregate Functions (GROUP BY, CUBE, ROLLUP, ...)

SQL - Part 2 - Aggregate Functions (GROUP BY, CUBE, ROLLUP, ...)

Aggregate Functions Aggregate functions are functions that are going to aggregate data from columns, or rows. Some of these functions are: SUM, AVG, MAX, MIN, …. . Special GROUP BY where we are going to group by values using a CASE and then sort by based on that case Example: In this

SQL - Part 1 - Advanced CASE Selecting

SQL - Part 1 - Advanced CASE Selecting

While I was studying the course Databases at the University of Ghent, we encountered some special queries that we were not being thaught in the Professional Bachelor course. This is why I tried to summarise those queries here for everyone to learn from. The database engine being used is Oracle

Solving a maze with Perl

Solving a maze with Perl

Mazes are really famous puzzles where the goal is to find the exit starting from an entrance. We can see these kind of puzzles as a labyrinth. When we found the solution we then draw over them to mark the path that we have to find. Most of the time