I have a table with 2 colums: Location Word
that looks like this:
Each location can have any number of words in it. I have a total of 31 locations (W1 thru W31).
I need a select statement that will select 1 random word from each location (i.e. returning 31 rows)
Can someone help me with this? Thank you.