|
|
Posted by Anthony Paul on 04/20/07 14:07
Hello Robert,
That wouldn't work since it groups by location_id and would return the
following :
location_id date_created
=========== ============
5 2000-01-01 01:05
2 2000-01-01 01:07
7 2000-01-01 01:08
I am looking into Mark's solution as we speak...
Regards,
Anthony
On Apr 20, 9:59 am, Robert Klemme <shortcut...@googlemail.com> wrote:
> On 20.04.2007 15:49, markc...@hotmail.com wrote:
>
> > If you are using SQL Server 2005, you can do this
>
> > with cte(location_id,date_created,grp)
> > as (
> > select location_id,
> > date_created,
> > rank() over(partition by location_id order by date_created)
> > - rank() over(order by date_created)
> > from mytable)
> > select location_id,
> > max(date_created) as date_created
> > from cte
> > group by location_id,grp
> > order by max(date_created)
>
> I'd do
>
> select location_id, max(date_created) date_created
> from your_table
> group by location_id
> order by max(date_created)
>
> Am I missing something?
>
> robert
Navigation:
[Reply to this message]
|