I tried using order by clause to sort and re-sort the data on the same column. My query was:
SELECT * FROM Customers ORDER BY Country ASC, Country DESC;
The result is surprising. It sorts the Country Column in Ascending Order only.
According to my knowledge, the Country Column should have been sorted in an Ascending order first, then in a Descending order.
Why did SQL skip the next part of the query?