Full Version:
Filter To List One Name From A Table Of Multiple Entries For Each Name.
UtterAccess Discussion Forums
>
And More...
>
Other Database Engines
dwhite913
Mar 2 2012, 11:03 AM
I have a table with multiple entries of the same name. How can I query the table and just list the name once?
theDBguy
Mar 2 2012, 11:07 AM
Hi,
You can try using the DISTINCT keyword in your query. For example:
SELECT DISTINCT FieldName FROM TableName ORDER BY FieldName;
Just my 2 cents...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here
.