David Scott wrote:
Putting it simply, I want the last record from the group, not the default
first.
Cheers
--
Dave
Dave:
I do not think your first query will give you the desired results either. You
cannot depend on which page_id you get from group by - this depends on what
decision the optimi
On Mon, 2004-03-08 at 15:52, David Scott wrote:
> OK, here is a problem that has been bugging me for some time.
>
> If I have a table like this, showing 3 visitors to a website and the pages they
> view
>
> idvisitorIDpageID
> 113
> 214
> 3
Putting it simply, I want the last record from the group, not the default
first.
Cheers
--
Dave
- Original Message -
From: "David Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 08, 2004 11:52 PM
Subject: Reversing the group...
OK, here is a
OK, here is a problem that has been bugging me for some time.
If I have a table like this, showing 3 visitors to a website and the pages they
view
idvisitorIDpageID
113
214
312
423
524
