I am trying to get 4 random hotels from each state. I can only get 1 random from each state.

Can anyone help

Code:


SELECT *

FROM(
SELECT *
FROM eanprod.activepropertylist
WHERE StateProvince IN("NW","WA","SA","NT","VC")
ORDER BY RAND()
) AS shuffled
GROUP BY StateProvince




I am trying to get 4 random hotels from each state. I can only get 1 random from each state. Can anyone help Code: --------- SELECT *

More...