-- 홀수 SELECT A.USER_ID ,A.USER_NAME FROM TEST where MOD(A.USER_ID, 2) = 1 -- 짝수 SELECT A.USER_ID ,A.USER_NAME FROM TEST where MOD(A.USER_ID, 2) = 0