Re: how to do this
Date: Mon, 28 Jun 1999 08:06:13 -0400
Message-ID: <37776534.A8A504BF_at_prodigy.net>
1 SELECT COUNTRY,sum(DECODE(year2,1996,data)) Y1996,sum(DECODE(year2,1997,data))
Y1997 ,sum(DECODE(year2,1998,data)) Y1998,sum(DECODE(year2,1999,data))
Y1999,sum(DECODE(year2,2000,data)) Y2000 from tdata
2* group by country
SQL> /
COUNTRY Y1996 Y1997 Y1998 Y1999 Y2000
---------- --------- --------- --------- --------- ---------
INDIA 1901 975 980 990 1991 USA 504 255 532 532 300
SQL> SELECT * FROM TDATA;
COUNTRY YEAR2 DATA
---------- --------- ---------
INDIA 1996 950 INDIA 1997 975 INDIA 1998 980 INDIA 1999 990 INDIA 2000 995 INDIA 2000 996 INDIA 1996 951 USA 1996 250 USA 1996 254 USA 1997 255 USA 1998 266 USA 1998 266 USA 1999 266 USA 1999 266 USA 2000 300
15 rows selected.
SQL> DESC TDATA;
[Quoted] Name Null? Type ------------------------------- -------- ---- COUNTRY VARCHAR2(10) YEAR2 NUMBER DATA NUMBER
SQL>
tRY This
may be solve your problem
Good luck
Qingbo Zheng wrote:
> The original table is
>
> JURISDICTION YEAR TOTAL_POPBIRTHS DEATHS NET_MIGRATION INTERNATIONAL
> DOMESTIC
> Delaware 1996 727113 10137 6459 4352 1347 2911 143 -49
> Delaware 1998 743603 10110 6235 4209 1254 3027 89 -30
> Kent 1998 124089 1745 785 534 124 332 56 -2
> Sussex 1998 136707 1623 1254 2334 2567 2677 4 -7
> New Castle 1998 482807 5698 3946 1078 1062 189 21 -38
> Delaware 1997 735143 10297 6340 4503 1417 3082 72 -68
> Kent 1997 122738 1808 976 519 137 337 54 -9
> New Castle 1997 478744 6718 3849 1194 1061 190 16 -73
> Sussex 1997 133661 1771 1515 2790 219 2555 2 14
> Kent 1996 121652 1840 1009 255 126 39 107 -17
> Sussex 1996 131078 1748 1522 2357 222 2159 5 -29
> New Castle 1996 468744 6617 3765 1067 1145 178 18 -9
>
> and I want to dissect it into tables by subject:
>
> Total Population
>
> REGION Y1996 Y1997 Y1998
> Kent 121652 122738 124089
> Sussex 131078 133661 136707
> Delaware 727113 735143 743603
> New Castle 468744 478744 482807
>
> Births
>
> REGION Y1996 Y1997 Y1998
> Sussex 1748 1771 1623
> New Castle 6617 6718 5698
> Kent 1840 1808 1745
> Delaware 10137 10297 10110
>
> Deaths
> REGION Y1996 Y1997 Y1998
> Sussex 1522 1515 1254
> New Castle 3765 3849 3946
> Kent 1009 976 785
> Delaware 6459 6340 6235
>
> etc
>
> Please give me a general idea on how to do this
> nested queries? procedures? I would like to see a procedure but I don't
> know how?
Received on Mon Jun 28 1999 - 14:06:13 CEST