y refSeq
having count(*) = 1;
> Date: Wed, 28 Jul 2010 11:10:32 -0500
> Subject: concatenate sql query with group by and having
> From: pengyu...@gmail.com
> To: mysql@lists.mysql.com
>
> mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A
mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A
I start mysql with the above command. Then I want to select the rows
from the result of the following query, provided that for any rows
that have the same symbol, chrom and strand should be the same
(basically, discard the rows that have the same s
