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