Select multiple columns from a table while ensuring that one specific column doesn't contain duplicate values.
SELECT Max(Clients.ClientID) AS MaxOfClientID, Clients.City
FROM Clients
GROUP BY Clients.City;
Select multiple columns from a table while ensuring that one specific column doesn't contain duplicate values.
SELECT Max(Clients.ClientID) AS MaxOfClientID, Clients.City
FROM Clients
GROUP BY Clients.City;