Back in around 2005, before the time of smart phones, I had some data. I can't remember what the data was, but I was told that for it ...

One of my favourite SQL analytic functions is row_number() , and I've used it in the past to identify, then remove duplicates. In this...

Last year I described a simple test case that described how to remove outliers from a fictional dataset using the STDDEV() analytical functi...

A colleague asked me about removing outliers from reports and I knew just the function to give a go. Some time ago I had to prove that som...

I've been following the LISTAGG problem for a while because I find the function useful. The problem being this error: ORA-01489: res...

Consider a chart with a trend that might be quite jagged across data points (blue line). What if you would like a smoother version of that...

Looking for way to apply analytical functions to your APEX applications? I had a classic report where I wanted to dynamically source the c...

In about 22 hours I'll be talking with Oracle Developer Advocate (or the southern/eastern hemisphere AskTom adjunct)  Connor McDonald a...

Thanks to twitter I found this post  by Carsten Czarski on LISTAGG and CLOBS that helped my with the 4000 character limit with LISTAGG(), fo...

SQL Analytics provides a fairly simple mechanism for determining positional rank within a set of results. Before I demonstrate that query ...

SQL analytics can be used to generate break columns in your queries, without the need for break formatting attributes in APEX or the old fas...

Being the APEX geek I am I've created a page that lists all the entrants so far to the Packt Publishing Phonegap ebook giveway Check i...

Today I found that SQL analytics go hand in hand with PIVOT statements. I had percentage data pivoted by a certain column, but I needed to...

Here is a simple example for when SQL Analytical Functions are simple yet useful. I wanted a basic 1,2,3,4 count so I could alternate col...

I had an interesting SQL problem at work recently, and I came up with a solution that I'm not sure is completely ideal - so I thought I...