I have the following query:
select carBrand, carYear, carModel from cars;
what I want is to get only different car names.
I wrote this, but it is not what i want.
select DISTINCT carBrand, carYear, carModel from Cars;
how can I solve this problem?
try
SELECT carBrand , carYear ,carModel
FROM Cars
GROUP BY carBrand , carYear ,carModel;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With