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

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

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

, 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

using DISTINCT after the ORDER BY clause has been applied

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.

using DISTINCT after the ORDER BY clause has been applied

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

using DISTINCT after the ORDER BY clause has been applied

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

Re: Selecting several columns using DISTINCT

At 4:46 PM +0100 2/3/02, Joseph Bueno wrote: Michael Collins a écrit : I am trying to normalize some MySQL tables and need to move a few columns from one table to another while maintaining the relationship between the two. SELECT DISTINCT ProductID (SELECT ProductID, SmImage,

Selecting several columns using DISTINCT

I am trying to normalize some MySQL tables and need to move a few columns from one table to another while maintaining the relationship between the two. I realize I cannot do a subselect, but in effect what I am wanting to do is to select the Distinct rows for the column ProductID and then

using DISTINCT

Hi, Is it possible to get all data; SELECT * FROM and still get some fields filtered by DISTINCT? Jari Mäkelä database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual)