Month: September 2018

The FIRST and LAST functions in Oracle SQL

Posted on September 27, 2018 by Carlos

This is the written version of a lesson from my SQL Course, in which I show how to use the FIRST and LAST functions. Like some other functions you probably know, these functions can be used either as aggregate functions… Continue Reading →

Pairwise Comparisons With Subqueries in Oracle SQL

Posted on September 11, 2018 by Carlos

I recently received a question about Pairwise Subqueries from one of the students in my SQL course, and I thought it would be a good idea to make my answer a blog post, since I did a couple of Google… Continue Reading →