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. In this
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 How can I
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 + '';
* 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
---
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