On Wed, 13 Jul 2011 12:26:02 -0600
Elim Qiu 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 < 100?
>
> In other words, how to get the list of yonger brother of the twin
> primes within certain bound?
>
se
> How about:
>
> select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
> t1.oid<100 order by t2.pv
>
> Mike
Very nice and simple. Thanks Mike!
Also Thanks Singer X.J. Wang and shawn wilson.
best regards,
Elim
--
MySQL General Mailing List
For list archives: http://lists.mysql
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|
| .|
+-+-
On Jul 13, 2011 2:26 PM, "Elim Qiu" wrote:
>
> I have a prime table
> +-+--+-+
> | oid | pv | descipt |
> +-+--+-+
> | 1 |2 | NULL|
> | 2 |3 | NULL|
> | 3 |5 | NULL|
> | 4 |7 | NULL|
> | 5 | 11 | NULL|
> | .
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
