On 3/14/07, Bill Guion [EMAIL PROTECTED] wrote:
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL
, Bill Guion [EMAIL PROTECTED] wrote:
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL PROTECTED]
Hello
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_id int unsigned page id of the page viewed
user_id int unsigned user id of the page viewed
ts timestamp timestamp of the page view.
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_idint unsignedpage id of the page viewed
user_id int unsigneduser id of the page viewed
ts timestamp
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL PROTECTED]
Hello:
I had a quick question on using