SQL cast desc

来源:互联网 发布:免费备案域名 编辑:程序博客网 时间:2024/04/29 17:22

SELECT CL_BadgeCount FROM ChatLog_Log WHERE CL_SenderID ='%@' ORDER BY CL_SendTime DESC,  cast(CL_BadgeCount as int) DESC  limit 1

SQL DESC CAST


SELECT  服务点,书名 FROM book where 服务点='004'   order by cast(天数 as int) desc  

使用cast把该值转化成int 然后再进行排序