SELECT ALL DISTINCT MAX_STATEMENT_TIME = 10 1 + 2 AS result, @idx, id, test.`users`.username AS FROM `test`.users PARTITION (p1, p2) WHERE id > 0 ORDER BY username DESC, id LIMIT 2, 3;