Hosting Provided By

Re: Delete query question

From: Alex Arul Lurthu <alex.lurthu(at)gmail.com>
Date: Wed Sep 05 2007 - 09:57:48 EDT

reply inline

On 9/5/07, Olaf Stein <steino@ccri.net> wrote:

> delete from geno_260k where ident=(select ident from geno_260k where a1=0
> group by ident having count(a1)>250000);

When a sub query returns more than one row in a where clause, then "=" should be replaced by the "in" .

-- 
Thanks
Alex
http://alexlurthu.wordpress.com

Received on Wed Sep 5 11:03:58 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:08:58 EDT