zaud #7214(2008/08/19 12:55 GMT) [ SQL ] Rating2/2=1.00
MySQL と oracle で動作を確認しました。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
SELECT DISTINCT t.x*v.y count_up FROM ( SELECT 0 x FROM DUAL UNION SELECT 1 FROM dual UNION SELECT 2 FROM dual UNION SELECT 3 FROM dual UNION SELECT 4 FROM dual UNION SELECT 5 FROM dual UNION SELECT 6 FROM dual UNION SELECT 7 FROM dual UNION SELECT 8 FROM dual UNION SELECT 9 FROM dual) t , (SELECT 1 y FROM dual UNION SELECT 10 FROM dual UNION SELECT 100 FROM dual UNION SELECT 1000 FROM dual UNION SELECT 10000 FROM dual UNION SELECT 100000 FROM dual UNION SELECT 1000000 FROM dual UNION SELECT 10000000 FROM dual UNION SELECT 100000000 FROM dual UNION SELECT 1000000000 FROM dual UNION SELECT 10000000000 FROM dual UNION SELECT 100000000000 FROM dual UNION SELECT 1000000000000 FROM dual) v WHERE t.x*v.y <= 300 ORDER BY t.x*v.y;
Rating2/2=1.00-0+
[ reply ]
zaud
#7214()
[
SQL
]
Rating2/2=1.00
Rating2/2=1.00-0+
[ reply ]