SQL Order by ASC and DESC
The following SQL statement selects all customers from the Customers table, sorted by columns Country and CustomerName , but what confused me the result , since the country result is alright 'cause it's ASC -By default so it started from A-Z , as well as the CustomerName should be ASC , But the result is not ! so it's not ASC , Why ?
Your result are indeed ordered correctly. It orders by Country first, THEN it orders by CustomerName. Within Argentina, your Customers are sorted correctly. Within Brazil, they are sorted correctly.
If you expected Comercio Miniero to be second in the list, ask yourself how that would impact your Country sort order. The sort order will do all the first column, then within that existing order, it will do the second column you listed.
- wordpress - Big post IDs, is it Okay in the future?
- Incorrect string value error for unconventional characters
- Cannot open include file: 'mysql.h': No such file or directory
- How do I connect Biostar V1.8 Suprema to MySQL?
- How to convert a string to date in MySQL?
- Duplicate records in MySQL. EXISTS check for the same data not working properly?
- How to define a custom ORDER BY order in mySQL
- On duplicate key ignore?
- How to fix MySQL providing duplicates that do not exist?
- What's the best MySQL alternative to dual?
- How can I connect an externally hosted MySQL database to BigQuery?
- DBeaver error resolving maven dependencies
- Easy way of generating a slug name column from the name column?
- MySQL crash on startup
- how to use custom.cnf in mysql server 8 docker-compose file?
- How can I allow django admin to set a field to NULL?
- error code 1292 incorrect date value mysql
- Configure wildcard catch-all email with Postfix
- Error 1329 in XAMPP application with MySQL trigger
- Which is the best way to insert a list inside a cell in SQL?
- Phpmyadmin doesn't accept MySQL trigger
- ST_Distance_Sphere in mysql not giving accurate distance between two locations
- How can I prevent SQL injection in PHP?
- UTF-8 all the way through
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Reducing memory consumption of mysql on ubuntu@aws micro instance
- INSERT ... ON DUPLICATE KEY UPDATE with WHERE?
- Find out where MySQL is installed on Mac OS X
- Copying BLOB from one server to another
- Liferay single database for two applications