ETL Dev

• Jul 25th, 2015

 

If the values have any ID values the usign mod function we can provide the details
mod(id,2)=0 will be even and mod(id,2)=1 will be odd

MUKUL MALIK

• Aug 22nd, 2016

 

SELECT customerid,case when customerID %2=0 then even
when customerID %2 < > 0 then odd end as result from customers

Sirisha d

 Profile Answers by Sirisha d 

• Jan 30th, 2017

 

Code
TO SELCT EVEN RECORDS IN ORACLE :


-----------------------------------------------


SELECT CUSTOMERID 


FROM


(SELECT 


CUSTIMERID,


CASE WHEN MOD(CUSTOMERID,2)=0 THEN EVEN WHEN (CUSTOMERID/2)=1 THEN ODD ELSE OTHER END AS EVEN_ODD


FROM


CUSTOMERS)


WHERE EVEN_ODD=EVEN


 


TO SELCT ODD RECORDS IN ORACLE :


-----------------------------------------------


SELECT CUSTOMERID 


FROM


(SELECT 


CUSTIMERID,


CASE WHEN MOD(CUSTOMERID,2)=0 THEN EVEN WHEN (CUSTOMERID/2)=1 THEN ODD ELSE OTHER END AS EVEN_ODD


FROM


CUSTOMERS)


WHERE EVEN_ODD=ODD