Dear all
A have a table mytable in which some records have the same value in
col1. I'd like to know how show up only once, how many twice, etc.
The following does what I want, but I think there should be a more
elegant way, possibly invlving subquires.
create table counts (n int);
insert into counts(n)
select count(*) from mytable group by col1;
select n,count(*) from counts group by n;
drop table counts;
Thanks for a hint,
W. Bauer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
