Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: query help.
Thanks Jerome, Can you give me some suggestion? ---------------------------------------------- Original Message Date: Thu, 22 Aug 2002 07:58:41 -0800 I'd synchronize your computer with the atomic clock at the US Naval Academy. What if your sysdate is actually 2.3 seconds off? Jerry Whittle ACIFICS DBA NCI Information Systems Inc. jerome.whittle@scott.af.mil 618-622-4145 -----Original Message----- Hey list Guru, Can anyone help me with this query? Many thanks, SELECT A.COUNTY_CODE, C.COUNTY_NAME, lpad(B.PRECINCT,4,' '), count(*), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(18*12))/(1*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(19*12))/(11*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(30*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(40*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(50*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(60*12))/(5*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(65*12))/(10*99)),1,0)), sum(decode(A.DOB, NULL, 1, 0)) FROM ONLINE_VOTERS A, ADDRESS_INDEX B, COUNTIES C WHERE A.COUNTY_CODE = B.COUNTY_CODE AND A.ADDRESS_ID = B.ADDRESS_ID AND A.COUNTY_CODE = C.COUNTY_CODE AND A.STATUS IN ('V','S') GROUP BY A.COUNTY_CODE, C.COUNTY_NAME, lpad(B.PRECINCT,4,' ') UNION ALL SELECT D.COUNTY_CODE, C2.COUNTY_NAME, lpad(D.PRECINCT,4,' '), count(*), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(18*12))/(1*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(19*12))/(11*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(30*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(40*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(50*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(60*12))/(5*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(65*12))/(10*99)),1,0)), sum(decode(D.DOB, NULL, 1, 0)) FROM OFFLINE_VOTERS D, COUNTIES C2 WHERE D.COUNTY_CODE = C2.COUNTY_CODE AND D.STATUS IN ('V','S') GROUP BY D.COUNTY_CODE, C2.COUNTY_NAME, lpad(D.PRECINCT,4,' ');