File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 33102

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
I agree. Here's the link:
subject: SQL question?
It's not a secret anymore!