Coding - SQL

7 posts
SQL - Recursion

SQL - Recursion

Introduction Recursion in SQL is a lesser known technique, this technique is just like we expect as it would work in any developing language such as C, Javascript, …, it allows us to create a query that will be able to recursively get and process data to find a result. Think...

SQL - Part 5 - Common Table Expressions

SQL - Part 5 - Common Table Expressions

CTE's (Common Table Expressions) are mostly used when creating recursive queries, creating temporary views (instead of subqueries). Calculating the dates of easter Use case And Example: We want to calculate the dates of when it is easter for the next hundred years. Solution:Since we are explaining examples in SQL...

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...

You’ve successfully subscribed to Xavier Geerinck
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.