摘要： 项目中sql语句源码：select top 5 *, ROW_NUMBER() OVER( order by LastUpdTime desc,id) as RowNumber from (select LastUpdTime'C'+convert(varchar(5),c.c_id) as id, shop.Shop_ID,shop.Shop_TEL,f.f_no,shop.Shop_storeys,shop.shop_mng,c.Pledge,c.LivingRoom,c.KitchenRoom,c.Bathroom,shop.title,shop.xiaoqu,shop. 阅读全文