MySQL中的UNIOn和ORDER BY问题

MySQL中的UNIOn和ORDER BY问题

尝试：

$getquery = "(SELECt * FROM highscore WHERe score >= '$score'ORDER BY score ASCLIMIT 6)UNIOn ALL -- guaranteed to be beneficial in this case as Johan commented(SELECt * FROM highscore WHERe score < '$score'ORDER BY score DESCLIMIT 5)";

或查阅精美的手册。