Re: How do you like this SQL?
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 15 Dec 2012 12:19:44 -0000
Message-ID: <L8KdnQLdgfRH91HNnZ2dnUVZ8kudnZ2d_at_bt.com>
| On Fri, 14 Dec 2012 04:09:43 -0800, dombrooks wrote:
|
| > It's not obvious that the model is messed up.
| > It's not clear that there is a table missing.
|
| So, why would one be computing maximum timestamp and do a group by in a
| sub-query?
|
Date: Sat, 15 Dec 2012 12:19:44 -0000
Message-ID: <L8KdnQLdgfRH91HNnZ2dnUVZ8kudnZ2d_at_bt.com>
| On Fri, 14 Dec 2012 04:09:43 -0800, dombrooks wrote:
|
| > It's not obvious that the model is messed up.
| > It's not clear that there is a table missing.
|
| So, why would one be computing maximum timestamp and do a group by in a
| sub-query?
|
It's one of the standard methods for "find the most recent occurrence"
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:pan.2012.12.14.17.00.48_at_gmail.com... Received on Sat Dec 15 2012 - 13:19:44 CET