SQL Query problem

[Shashi Iyy]

Hi All,
Suppose there is a table as below :

SkillName SkillCode Beginner Proficient Experienced
Java 001 2 0 0
Java 001 0 3 0
Java 001 0 0 1

The above table suggests that for the skill Java,there are 2 Beginners,3 Proficient and 1 Experienced people.

I need to write a query which will query the above table and retrieve the results in the form given below :

SkillName SkillCode Beginner Proficient Experienced
Java 001 2 3 1

Can anyone explain me as to how to go about this?A example would be much better.Thanks in advance.

[Rajkamal Pillai]

Hi

Tried using the MAX() function for the Beginner, Proficient and Experienced columns?

Cheers,
Raj.

[Hemavathy Ramamoorthy Gopal]

Hi,

Using Sum() with group by will also result in same format.


Regards,
Hema.

[Campbell Ritchie]

"Hemavathy RG" you have already been warned about your displayed name. Please go to "my profile" and change it.

[Hemavathy Ramamoorthy Gopal]

Hi Campbell Ritchie,

I think content/solution provided according to raised queries/problem highly matters instead of display name and other stuff.

[Hemavathy Ramamoorthy Gopal]

Hi Campbell Ritchie,

I think content/solution provided according to raised queries/problem highly matters instead of display name and other stuff.

[Campbell Ritchie]

Experience shows that using real names makes for a friendlier atmosphere; if you lose the atmosphere you lose the participants and then there will be no replies at all.

So the naming policy is a long-term way of ensuring there will be answers to the questions.

[Hemavathy Ramamoorthy Gopal]

Ok agreed.

[Campbell Ritchie]

Originally posted by Hemavathy Ramamoorthy Gopal:
Ok agreed.