RE: Select and COUNT

www.giiexpress.com www.etudes-marche.com > -Original Message- > From: spacemarc [mailto:[EMAIL PROTECTED] > Sent: Friday, June 08, 2007 5:13 AM > To: MySQL > Subject: Select and COUNT > > Hi all, > I have this query: > > SELECT tableA.*, COUNT(*) AS Tot > FROM tableB

Re: Select and COUNT

Hi, spacemarc wrote: 2007/6/8, Baron Schwartz <[EMAIL PROTECTED]>: Use a LEFT OUTER JOIN, but reverse it; join from tableA to tableB. You may be looking for a FULL OUTER JOIN, I'm not sure. MySQL doesn't support that, but see: http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-joi

Re: Select and COUNT

Hi spacemarc, spacemarc wrote: Hi all, I have this query: SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid This query shows only the users (tableA) that are in tableB with at least 1 record (like total) but not the users that have 0 rec

Select and COUNT

Hi all, I have this query: SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid This query shows only the users (tableA) that are in tableB with at least 1 record (like total) but not the users that have 0 record. How can I obtain all users,

SELECT and count fields

Hi I have this select: SELECT tab1.field, tab2.field, tab3.field FROM table JOIN JOIN WHERE tab4.type=b GROUP BY etc ORDER BY etc Now, the tab4 has three fields: id, color, type. I want to select where type=b and to count all the occurrences of color in the same query. Example:

RE: Select and count duplicates

select distinct(headlines), count(headlines) from table group by headlines -Original Message- From: David Shapiro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:40 AM To: 'Michelle de Beer'; mysql list Subject: RE: Select and count duplicates Run this qu

Re: Select and count duplicates

* Michelle de Beer > I have a column containing headlines. In this column > there are some duplicates, like this: > --- > monsters > headline1 > monsters > halloween > monsters > halloween > ... > -- > > How can I get a result like this instead? > HEADLINE | HITS > -

RE: Select and count duplicates

MAIL PROTECTED]] Sent: Tuesday, December 03, 2002 7:27 AM To: mysql list Subject: Select and count duplicates I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I

re: Select and count duplicates

Michelle, Tuesday, December 03, 2002, 2:27:00 PM, you wrote: MdB> I have a column containing headlines. In this column MdB> there are some duplicates, like this: MdB> --- MdB> monsters MdB> headline1 MdB> monsters MdB> halloween MdB> monsters MdB> halloween MdB> ... MdB> -- MdB> H

RE: Select and count duplicates

SELECT headline, count(*) AS HITS from your_table GROUP BY headline > -Original Message- > From: Michelle de Beer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 8:27 AM > To: mysql list > Subject: Select and count duplicates > > > I have a column

Fw: Re: Select and count duplicates

- Original Message - From: <[EMAIL PROTECTED]> To: "DL Neil" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 1:05 PM Subject: Re: Re: Select and count duplicates > Your message cannot be posted because it appears to be either spam or > simply off topic

RE: Select and count duplicates

D]] Sent: Tuesday, December 03, 2002 7:27 AM To: mysql list Subject: Select and count duplicates I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I get a resu

RE: Select and count duplicates

select headline, count(*) from headlines_table group by headline; Eva Parackova [EMAIL PROTECTED] -Original Message- From: Michelle de Beer [mailto:[EMAIL PROTECTED]] Sent: 3. decembra 2002 13:27 To: mysql list Subject: Select and count duplicates I have a column containing headlines

Select and count duplicates

I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I get a result like this instead? HEADLINE | HITS --- monsters | 3 halloween | 2 headline1

select and count

Hi, We have a transaction table that has a field called userid. Each time a user makes a purchase, this table get populated. I am using the following query to get the no of transactions per user: select userId, count(*) from transactions group by userid I am using the following query to get a l