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.