[mysql] mysql query order by multiple items

SELECT some_cols
FROM prefix_users
WHERE (some conditions)
ORDER BY pic_set DESC, last_activity;

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to sql-order-by

• Laravel Eloquent: Ordering results of all() • SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 • SQL ORDER BY multiple columns • How to use Oracle ORDER BY and ROWNUM correctly? • MySQL order by before group by • Ordering by specific field value first • MySQL ORDER BY multiple column ASC and DESC • How can I get just the first row in a result set AFTER ordering? • SQL order string as number • Order by multiple columns with Doctrine