摘要:
select sum(case when xseventype'' then 1 else 0 end), sum(case when zaeventype'' then 1 else 0 end),hotelcode from info_hotelevent group by hotelcode 阅读全文
摘要:
select isNull(max(EvenId),0) as teevenid from info_hotelevent where hotelcode like '4506020003%' select max(EvenId) as teevenid from info_hotelevent where hotelcode like '4506020003%' 阅读全文