SELECt id_one, id_two, timestamp_one, timestamp_two FROM tablename WHERe id_one = 27 OR id_two = 27 ORDER BY CASE WHEN id_one=27 THEN timestamp_one WHEN id_two=27 THEN timestamp_two END DESC
SELECt id_one, id_two, timestamp_one, timestamp_two FROM tablename WHERe id_one = 27 OR id_two = 27 ORDER BY CASE WHEN id_one=27 THEN timestamp_one WHEN id_two=27 THEN timestamp_two END DESC
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
