It’s not applying for 2nd column that I mentioned, it’s only applying for 1st column not for 2nd one
SELECT SupplierID, CompanyName, City, Country
FROM Suppliers
ORDER BY Country DESC, City DESC;
I tried this command to make country in descending order and city as ascending order, but it’s only applying for country column – what to do what mistake have I done?
New contributor
Sushmi Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.