List:General Discussion« Previous MessageNext Message »
From:mos Date:July 13 2011 6:44pm
Subject:Re: query for twin primes
View as plain text  
At 01:26 PM 7/13/2011, you wrote:
>I have a prime table
>+-----+------+---------+
>| oid | pv   | descipt |
>+-----+------+---------+
>|   1 |    2 | NULL    |
>|   2 |    3 | NULL    |
>|   3 |    5 | NULL    |
>|   4 |    7 | NULL    |
>|   5 |   11 | NULL    |
>|  .....................    |
>+-----+------+---------+
>
>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?
>
>Thanks


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


>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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