Hi,
I have a staff table like this:
name year salary
============================
a 1998 50
a 1999 100
a 2000 200
a 2001 300
b 2000 200
b 2001 300
I want to get a new table from the above table:
name salary(1998) salary(1999) salary(2000) salary(2001)
===================================================================
a 50 100 200 300
b 0 0 200 300
What's the SQL for this problem? I will invoke the sql code in my
java code.
Thanks.