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

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: [email protected] >>>From: "Yashesh Bhatia" <[EMAIL PROTECTED]> >>>S

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: [email protected] >From: "Yashesh Bhatia" <[EMAIL PROTECTED]> >Subject: using DISTINCT after the ORDER BY c

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: [email protected] 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

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

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

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,

Re: Selecting several columns using DISTINCT

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. I realize I cannot do a subselect, but in effect > what I am wanting to do is to select the Distinct rows for t

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 sele

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) ht