Oracleã§ã©ã³ãã ã«ã¬ã³ã¼ããåå¾ããã®åçã«æ©ãæ¹æ³ãããã¾ããã ä»ã¾ã§ã¯ä¹±æ°çºçããã¦ã½ã¼ããã¦ããã®ãé¢æ°ï¼ã¤ã§æ¸ãããã«ãªãã¾ãã ãã¼ãã«ã»ãã¼ã¿ãã©ã³ãã ãµã³ããªã³ã°ãã - Oracle/ãªã©ã¯ã«ããã¹ã¿ã¼ããããã®åºæ¬ã¨ä»çµã¿ã§ç´¹ä»ããã¦ãã¾ãã SAMPLEã¨ããé¢æ°ã使ããã¨ã§é度ãåçã«æ©ããªãã¾ããã é¢æ°ã®èª¬æã¯ãªã³ã¯å
ãåç
§ãã¦é ãã¨ãã¦å®éã«ãã³ããè¨ã£ã¦ã¿ã¾ããã ç´40ä¸ã¬ã³ã¼ãã®ãã¼ãã«ãã10è¡ãã©ã³ãã ã«åå¾ããSQLã§è¨æ¸¬ãã¾ããã SAMPLE使ããªãæ¹æ³ SELECT WORD FROM (SELECT dbms_random.random() as rand, WORD FROM TEST ORDER BY rand) WHERE ROWNUM <= 10; å®è¡æé: 3.11698914ç§ SAMPLE使ãæ¹æ³ SELECT WOR
{{#tags}}- {{label}}
{{/tags}}