How do I return a list of unique account numbers?

I have a table that lists all the billing codes assigned to each account.  I want to create a table that will lists the account that don't have a certain code and put those records into a new table.  Since the same account number can be listed multiple times in the table I am querying, how do I get the account to only appear once in the table I want to create?

Who is Participating?

Improve company productivity with a Business Account.Sign Up

brad2575Connect With a Mentor Commented:
You just do a "Select Distinct AccountNumber " 

The distinct keyword gets unique numbers.

vsllcAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.