Thank you all who helped me out on this..
I had tried the distinct but not inside the count.
I was using the group by because this could have multiple returns but
after adding the distinct to inside the count it worked like a
charm!!!
Thanks to everyone who helped out on this one!
At 05:01 PM 10
SELECT COUNT(*) from mytable
---
Bastianello Luciano
Software Consultant - Apprentice Sorcerer
e-mail: [EMAIL PROTECTED]
e-mail: [EMAIL PROTECTED]
ICQ: 209754422 - MSN: [EMAIL PROTECTED]
---
---
How about ...
select count(distinct this) from table
John Sidney-Woollett
Dev wrote:
Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of th
* Dev <[EMAIL PROTECTED]> [2004-10-14 16:54:56 -0400]:
> I am trying to get a total number of rows returned form a query.
>
> SELECT count(this) from table group by this
Remove the 'group by' clause -- you don't need it.
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.com
Dev wrote:
Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of the rows returned!
SELECT COUNT(DISTINCT this) FROM table
Andre
Hello all,
I am trying to get a total number of rows returned form a
query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the
group by.
I need the count of the rows returned!
Any way to do this?
Brian C. Doyle
Director, In
