Have you tried

select field1,field2,.....
from tablename
group by field1, field2,....

Tim


"Prakash" wrote in message
...
Hi,
I wanted to use Distinct Command thro MS query (excel)for filtering
duplication from other database. PLs confirm how i can use & syntax for
the
same.

I have tried "SELECT DISTINCT FIELD1,FIELD2,..... FROM TABLE"

Regards