Duplicate Records

[TimC]

I receive a quarterly database from a third party. The database includes multiple tables. One of the tables includes 45,000 rows of data and includes things like name, department, address, etc. I’m trying to build a query that pulls the 20 or so department names but I get 45,000 records (lots of duplicates) because the way the third party enters data into the database. Is there an easy way to filter out the repeats so I only get the 20 or so department names? FYI - There is not a separate table that includes the list of departments. Thanks.

Tim

[June7]

Try:

SELECT DISTINCT Department FROM tablename;

[TimC]

That worked perfectly. Thank you.

Try:

SELECT DISTINCT Department FROM tablename;