?? random.sql
字號:
---- test the random function---- count the number of tuples originallySELECT count(*) FROM onek;-- select roughly 1/10 of the tuples-- Assume that the "onek" table has 1000 tuples-- and try to bracket the correct number so we-- have a regression test which can pass/fail-- - thomas 1998-08-17SELECT count(*) AS random INTO RANDOM_TBL FROM onek WHERE oidrand(onek.oid, 10);-- select again, the count should be differentINSERT INTO RANDOM_TBL (random) SELECT count(*) FROM onek WHERE oidrand(onek.oid, 10);-- now test the results for randomness in the correct rangeSELECT random, count(random) FROM RANDOM_TBL GROUP BY random HAVING count(random) > 1;SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -