SQL: To check whether age is greater than 26.

-


The Below SQL is useful to calculate the employee age who are having greater than 26 years:

 AND (PER.RELATIONSHIP IN('X','XN')
    OR ((TRUNC((to_number(TO_CHAR(%CurrentDateIn ,'yyyymmdd'))-to_number(TO_CHAR(PER.BIRTHDATE ,'yyyymmdd')))/10000)) > 26
   AND PER.DISABLED ='N' AND PER.RELATIONSHIP ='C' ) )


 AND

(

   PER.RELATIONSHIP IN('X','XN')  OR
   ((TRUNC((to_number(TO_CHAR(%CurrentDateIn ,'yyyymmdd'))-to_number(TO_CHAR(PER.BIRTHDATE ,'yyyymmdd')))/10000)) > 26

   AND PER.DISABLED ='N'   AND PER.RELATIONSHIP ='C' )

    OR (PLN.COVERAGE_ELECT='T'  AND PLN.COVERAGE_BEGIN_DT <= %Bind(IIE_WEEK_RUN_DATE))

)



AND (


   PER.RELATIONSHIP IN('X','XN')
 
OR (

(

(TRUNC((to_number(TO_CHAR(%CurrentDateIn ,'yyyymmdd'))-to_number(TO_CHAR(PER.BIRTHDATE ,'yyyymmdd')))/10000)) > 26
   AND PER.DISABLED ='N'
   AND PER.RELATIONSHIP ='C' )  OR (PLN.COVERAGE_ELECT='T' AND PLN.COVERAGE_BEGIN_DT <= %Bind(IIE_WEEK_RUN_DATE)

)

) 

Comments

Post a Comment

Popular posts from this blog

BI Publisher: If Condition with sub-string in rtf template

-
 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;
Read more