This is an old revision of the document!


SQL 4등분 rand() 함수

조심하자..

CASE 
    WHEN RAND() <= 0.25 THEN '1'      -- 25%의 확률
    WHEN RAND() <= 0.33 THEN '2'      -- (1-0.25) * 33% = 24.75%의 확률
    WHEN RAND() <= 0.5 THEN '3'       -- (1-0.25-0.2475) * 50% = 26.25%의 확률
    ELSE '4'                          -- 나머지 확률: 1 - (0.25 + 0.2475 + 0.2625) = 25%
END
Enter your comment. Wiki syntax is allowed:
G Q J K᠎ M
 
  • data_analysis/sql/sql_rand_split_4.1732251798.txt.gz
  • Last modified: 2025/07/07 14:12
  • (external edit)