On Wed, 13 Jul 2011 12:26:02 -0600 Elim Qiu <elim....@gmail.com> wrote:
> I have a prime table > > what the query will be if i like to find all rows where pv+2's are > also in colum 'pv', where oid < 1000000? > > In other words, how to get the list of yonger brother of the twin > primes within certain bound? > select prime.* from prime join prime as p2 on prime.pv+2=p2.pv where prime.oid < 1000000; -- Simcha Younger <sim...@syounger.com> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org