wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes SQL question? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

SQL question?

George Liao

Joined: May 20, 2003
Posts: 14

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.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32819

Sushil posted the exact same question. I'm closing this (I picked one randomly) so that all the discussion can continue in one place.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Don't get me started about those stupid light bulbs.
subject: SQL question?
It's not a secret anymore!