#MySQL排序

-- Default is ASC

-- Sort by name alphabetically

-- Use DESC for descending

-- Newest first

-- Sort by multiple columns

-- Different directions

-- Three columns

-- Sort by column position in SELECT

-- Multiple positions

-- Sort by string length

-- Sort by part of string

-- Case-insensitive sort

-- Sort by calculation

-- Sort by absolute value

-- Sort by date part

-- Sort by time only

-- Sort by relative date

-- NULLs first (default ASC)

-- NULLs last

-- In MySQL (NULLs are lowest by default)

-- Treat NULL as specific value

-- Multiple NULL columns

-- Get top 10 most expensive products

-- Get newest 5 users

-- Get oldest 10 orders

-- Page 1 (records 1-10)

-- Page 2 (records 11-20)

-- Page 3 (records 21-30)

-- Random selection

-- Random product

-- Shuffle results

-- Sort joined results

-- Sort by aggregate

-- Sort grouped results

-- Sort by aggregate

-- Sort subquery results

-- UNION with ORDER BY

-- Different collation

-- Default is case-insensitive for utf8mb4

-- Case-sensitive sort

-- Index helps for sorted columns

-- Composite index for multiple columns

-- Expression on column

-- Function on column

-- Mixed directions

-- Sort by price: low to high

-- Sort by price: high to low

-- Sort by rating

-- Sort by newest

-- Recently active users

-- Users by registration date

-- Alphabetical by last name

-- Sales by amount

-- Top customers