This is the written version of a lesson from The Ultimate Oracle SQL Course, in which I show how to use the Oracle FIRST and LAST functions. Like some other functions you probably know, these functions can be used either… Continue Reading
Ranking functions are some of the most commonly used analytic functions, and although the “ranking” category can quickly make you think about Top-N queries, that is actually not the only type of problems you can solve with them. In this… Continue Reading
Analytic functions in Oracle SQL are very useful and are utilized by many people, but sometimes without completely understanding how they work or what data they operate on. This article does not focus on a specific function, but on analytic… Continue Reading