data_analysis:sql:sql_rand_split_4

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:
A N K D G
 
  • data_analysis/sql/sql_rand_split_4.txt
  • Last modified: 2025/07/07 14:12
  • by 127.0.0.1