I have table with 2 columns and 4 rows. colA is unique. ColB values are same for each of 2 rows.
Here is the actual data in table
ColA ColB
-----------------------
1 PRODUCT
2 PRODUCT
3 PRICE
4 PRICE
I am trying to get output from a single query as below.
1,2 -- PRODUCT
3,4 -- PRICE
Can someone please advise how to write this query.
