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
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
-in-mysql/
I've inverted, like you said, the tables and used LEFT OUTER JOIN:
SELECT tableA. * , COUNT( tableB.uid ) AS Tot
FROM tableA
LEFT OUTER JOIN tableB ON tableB.uid = tableA.uid
GROUP BY tableA.uid
and it works.
I also tried this other:
SELECT tableA.*, COUNT(tableB.uid) AS Tot
FROM
SELECT tableA.*, COUNT(*) AS Tot
FROM tableB
LEFT OUTER JOIN tableA ON tableA.uid=tableB.uid
GROUP BY tableA.uid
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
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:
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
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
Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this query as rs2
query = 'select count(*) from monster_table where scary_words=' +
word
- 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 to our filter. To bypass the filter
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 containing headlines
get a result like this instead?
MdB HEADLINE | HITS
MdB ---
MdB monsters | 3
MdB halloween | 2
MdB headline1 | 1
MdB ---
SELECT headline, COUNT(*) as hits FROM table_name GROUP BY headline
--
For technical support contracts, goto https
Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this sql query as rs2
query = 'select count(*) from monster_table where scary_words=' +
word
---
monsters | 3
halloween | 2
headline1 | 1
---
This is a basic GROUP BY query:
SELECT headline, count(*) hits
FROM headlinetable
GROUP BY headline
ORDER BY hits DESC
URL: http://www.mysql.com/doc/en/SELECT.html
URL: http://www.mysql.com/doc/en
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 query as rs1
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
15 matches
Mail list logo