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,' ');
_____________________________________________
Free email with
personality! Over 200 domains!
http://www.MyOwnEmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: cw
INET: cw@netlimit.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 22 2002 - 12:03:36 CDT
