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;
Find out why we do it for less.
AUST IT will help you resolve any technical support issues you are facing onsite or remotely via remote desktop 24/7. More...
Reservoir, Melbourne,
3073, VIC, Australia
Phone: 0422 348 882
This email address is being protected from spambots. You need JavaScript enabled to view it.
Sydney: 0481 837 077
Join us in social networks to be in touch.