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
I have a table with multiple entries of the same name. How can I query the table and just list the name once?
theDBguy
Hi,

welcome2UA.gif

You can try using the DISTINCT keyword in your query. For example:

SELECT DISTINCT FieldName FROM TableName ORDER BY FieldName;

Just my 2 cents... 2cents.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.