获取降序但在mysql中显示为升序[关闭]

Question

I want to fetch last records but display as ascending order not descending order.

 SELECT R.cr_id, 
        R.time, 
        R.reply, 
        U.id, 
        U.username,
        U.firstname, 
        U.lastname, 
        U.email, 
        U.image 
     FROM (HM_customers U, HM_conversation_reply R) 
     WHERE R.user_id_fk = U.id AND R.c_id_fk = '1' 
     ORDER BY R.cr_id DESC LIMIT 20 

Edit...

I am using two tables.

Answer 1

below code working for me.

   SELECT t.cr_id, 
    t.time, 
    t.reply, 
    t.id, 
    t.username,
    t.firstname, 
    t.lastname, 
    t.email, 
    t.image 
 FROM (
 SELECT R.cr_id, 
    R.time, 
    R.reply, 
    U.id, 
    U.username,
    U.firstname, 
    U.lastname, 
    U.email, 
    U.image 
 FROM (HM_customers U, HM_conversation_reply R) 
 WHERE R.user_id_fk = U.id AND R.c_id_fk = '1' 
 ORDER BY R.cr_id DESC
 limit 20
 ) t
 ORDER BY t.cr_id ASC