If I have a column with three different inputed variables, can I use sql to give me a percentage for that column.Here is an example.
column
__________
red
red
red
blue
blue
orange
sql output >
column column(percentage)
________ _________________
red 50%
blue 30%
orange 20%
Thanks for any help!
Trev