Multiple distinct
662385Nov 3 2008 — edited Nov 4 2008I wish to Have many cols with the distinct function attached in one statement if possible, I think the closest to this may be the union but it is all returned in one column. any possibility that you can get it to show in multiple columns? eg i have(animal col) dog dog cat (house number col) 13 23 17 21 23 so they show dog cat in one col 12 23 17 21 and the numbers in another
I am using oracle 11g