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 100?
In other words, how to get the list of yonger brother of the twin
primes within certain
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
On Jul 13, 2011 2:26 PM, Elim Qiu elim@gmail.com wrote:
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
|
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|
| .|
How about:
select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
t1.oid100 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: