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/[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
