SELECT multiple column values

Show us sample data and expected output to make your question clear.