SQLTeam.com | Weblogs | Forums

How to list code in 2 separate columns using a SQL query

I have columns SalaryCode, SalaryName with sample values like this:

salarycode salaryname

1        basic
1        DA
1        PF
2        contributions
2        deductions

I want to get in query

code salary name code salary name
1 basic 2 contributions
1 DA 2 Deductions
1 PF

Do you just have the two salarycode values?
If there are more do you what them to be their own columns?

What have you tried? What problems are you having?