Wilfried Mestdagh a écrit :
Hello,
I'm not sure if subject make sence (English is not my mothers tongue), I
try to explain:
I have a table and a field called 'Name' can have a lot of the same but
also different values. I want (if exists of course) to do a query where
I only get as result the exclusive names. I give example to make more
sence:
in table 'Name' field:
a
a
a
b
b
b
b
c
c
c
In result of query I only want the records (so in this case only 3
records with the 'Name' field:
a
b
c
Is this possible ?
Hi Wilfried,
Yes, it's possible with :
select distinct name from table_name;
you can also have the exact count for each value with :
select name, count(name)
from table_name
group by name;
HTH,
Best regards,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com