mysql 视图里面如何写时间排序

Question

mysql 视图里面如何写 时间升降 排序 让这个字段：TJRQ 在数据里面显示

TJRQ 字段 这个是 时间

麻烦 帮忙写一下！

补充：

Answer 1

直接 最后 加上如下

order by `A`.`TJRQ`  asc // 升序
order by `A`.`TJRQ` desc // 降序

Answer 2

最后加上排序

order by A.TJRQ desc

Answer 3

稍等

with temp as (
      select a.bmzjhm as sfzh, a.jkzbh as jkzbh, a.xm as xm, a.nl as nl,
     (
      case a.xb when '0' then '女' 
                when '1' then '男' 
                else '不详' end
     ) as xb,b.mc as gz, a.tjrq as tjrq, a.fzrq as fzrq, c.phone as shh
from (
      (ggws_Tjzm as a join tj_fwhy as b on a.hy=b.bh)
       join tj_tjDJB as c on c.tjbh=a.tjbh)
)
select * from temp order by tjrq desc