List:General Discussion« Previous MessageNext Message »
From:Elim Qiu Date:July 13 2011 7:26pm
Subject:Re: query for twin primes
View as plain text  
> How about:
>
> select  t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
> t1.oid<1000000 order by t2.pv
>
> Mike

Very nice and simple. Thanks Mike!

Also Thanks Singer X.J. Wang and shawn wilson.

best regards,
Elim
Thread
query for twin primesElim Qiu13 Jul
  • Re: query for twin primesshawn wilson13 Jul
  • Re: query for twin primesmos13 Jul
    • Re: query for twin primesElim Qiu13 Jul
  • Re: query for twin primesSimcha Younger14 Jul