Oracle SQL Tips, Tricks and Hacks
Everything Oracle SQL
Menu Close
  • Blog
  • Video Courses
  • Oracle SQL Tutorial

Month: September 2018

1

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 →

Functions, SQL aggregate, analytic, FIRST, function, functions, LAST, Oracle, SQL
3

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 →

SQL Oracle, SQL, Subquery
Don't want to miss any Oracle SQL tips?

Subscribe to be informed about new posts, tips and more awesome things.

Recent Twitter Activity

Recent Tweets by @CarlosDLG

Recent Posts

  • The SQL Group By Clause
  • The Oracle Multitenant Architecture
  • The FIRST and LAST functions in Oracle SQL
  • Pairwise Comparisons With Subqueries in Oracle SQL
  • How to Change Oracle SQL Developer Language

Categories

  • Basics
  • Functions
  • Oracle Database
  • SQL
  • SQL Developer
  • Tuning

Archives

  • March 2019
  • September 2018
  • April 2018
  • January 2017
  • October 2016
  • August 2016
  • June 2016
  • April 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
© 2021 Oracle SQL Tips, Tricks and Hacks. All rights reserved.
Hiero by aThemes
Shares