samedi 4 avril 2015

SQL Select - Distinct - Random

these are fields of my table table1 (position, club, country, flag) and


and I need to show randomly club name without repeating the country,


a use this query



select top 4 position
from table1 where flag = 0
and exists(select distinct country from table1) order by newid()


but turns out to repeat the name of the country,


can you help me?


thank you,


AM





Aucun commentaire:

Enregistrer un commentaire