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
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
52
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 problem that has been
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
31