Friday, April 15, 2011

mysql group by and having

mysql> select CASNumber, count(CASNumber) as ccas from compounds group by CASNumber having ccas=1 order by ccas ;

No comments:

Post a Comment