Re: using DISTINCT after the ORDER BY clause has been applied

2007-03-14 Thread Yashesh Bhatia
t;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]> >>>S

Re: using DISTINCT after the ORDER BY clause has been applied

2007-03-14 Thread Yashesh Bhatia
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 c

using DISTINCT after the ORDER BY clause has been applied

2007-03-13 Thread Bill Guion
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 h

using DISTINCT after the ORDER BY clause has been applied

2007-03-13 Thread Yashesh Bhatia
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 unsigned"page id of the page viewed" user_id int unsigned"user id of the page viewed" ts timestam

using DISTINCT after the ORDER BY clause has been applied

2007-03-13 Thread Yashesh Bhatia
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