Ok here's the current method I'm using to find non-distinct records in a
table:
1) SELECT DISTINCT column1 FROM table WHERE column2='something'
2) I get an array and mash it together [PHP: $biglist =
'.implode(',',$column).';]
3) SELECT column1 FROM table WHERE column1 NOT IN($biglist);
now
On 15-Aug-2001 Stephen VanDyke wrote:
Ok here's the current method I'm using to find non-distinct records in a
table:
1) SELECT DISTINCT column1 FROM table WHERE column2='something'
2) I get an array and mash it together [PHP: $biglist =
'.implode(',',$column).';]
3) SELECT column1
Incredibly difficult.
select foo,count(*) as cnt from da_table group by foo having cnt 1;
ahh, I'd be slapping my forehead right now, except I've never used having
Thanks for helping out. :)
Stephen
-
Before posting,
hey guys
I need something similar:
first and foremost, i need all the info about evry customeri have, and then
a count of how may order then have for me. (never got it working)
im guessing something like this
select *,count(*) as orders from C,O group by O.domain having orders-1
however, this
