经典排序SQL

                                                                       经典排序SQL

排序要求：类型为2的排在前面，其他的类型不排序；然后再按最后更新时间倒序排序。

"from Topic t where t.forum=? order by (case t.type when 2 then 2 else 0 end) desc,t.lastUpdateTime desc"

 

查询ZHIFA_QT_INFO中time不为空的数据，并翻译所有的区县、街道、活动地点。

 

select Z.QT_NAME, Z.ADDRESS, x1.TYPE_NAME as QX,x2.TYPE_NAME as JD, x3.TYPE_NAME as ACTIVITY_LOCATION, Z.MAINTAIN_DATE
 from zhifa_qt_info z left join xt_dic_resource x1 on Z.ACTIVITY_ADDRESS_QX=x1.TYPE_ID
  left join xt_dic_resource x2 on (Z.ACTIVITY_ADDRESS_JD=x2.TYPE_ID and X2.CATALOG=Z.ACTIVITY_ADDRESS_QX)
  left join xt_dic_resource x3 on (Z.ACTIVITY_LOCATION=x3.TYPE_ID and X3.CATALOG=Z.ACTIVITY_ADDRESS_JD)
 where z.registration_date is not null;

经验总结