title: Using Oracle 9i comparing 2 years
body: <p>I have a list of Rainfall data </p>
  
  <pre><code>SELECT * FROM Rainfall
  
  COUNTRY         YEAR  AMT
  --------------  ----  ---
  Austria         2000  1.1
  Belgium         2000  1.2
  France          2000  1.3
  Ireland         2000  1.4
  
  France          2001  1.5
  Ireland         2001  1.6
  
  Austria         2002  1.7
  Belgium         2002  1.8
  France          2002  1.9
  
  Germany         2003  2.0
  Italy           2003  2.1
  </code></pre>
  
  <p>How would I select this showing all countries for 2 consecutive years</p>
  
  <pre><code>COUNTRY          YEAR 2001   YEAR 2000
  -------          ---------   ---------
  Austria           -            1.1
  Belgium           -            1.2
  France            1.5          1.3
  Ireland           1.6          1.4
  </code></pre>
  
  <p>Then in 2002 - 2001</p>
  
  <pre><code>COUNTRY          YEAR 2002   YEAR 2001
  -------          ---------   ---------
  Austria           1.7          -
  Belgium           1.8          -
  France            1.9          1.5
  Ireland           -            1.6
  </code></pre>
  
  <p>Finally 2003 - 2002</p>
  
  <pre><code>COUNTRY          YEAR 2003   YEAR 2002
  -------          ---------   ---------
  Austria           -           1.7          
  Belgium           -           1.8          
  France            -           1.9          
  Germany           2.0         -
  Italy             2.1         -
  </code></pre>
  
  <p>Thanks.</p>