Getting only one result of each entry in a select

[nozom]

i have a table of users, each has a country ID which links to which country they are from.

I want to select all of the countries that are listed in the database but only return one of each value. Can this be done with an SQL statement?

ex: USER jim Country_ID=13
USER sam Country_ID=25
USER veronica Country_ID=13

will return a list with
COUNTRY = 13
COUNTRY = 25

ta,
hugh

[khaldryck]

select distinct country_id from User order by country_id

this will get you each country in your User table, but only once.

[nozom]

rock on!! cheers,
Hugh