摘要:
select t9.region_name 区,(select region_name from crm_region r1 where r1.region_id=t9.parent_id) 市,(select region_name from crm_region r1 where r1.regi... 阅读全文
摘要:
FX="'"&A2&"'," 阅读全文
摘要:
/*order_time在数据库中显示的是vchar类型,这里把它转换成了data类型*/select t1.order_source_type_id ,sum(average)/count(order_sn),count(order_sn) from ( select t1.order_sn,t1... 阅读全文
摘要:
1.t表是f表的子表,现在要从f表中去掉t表中的数据select f.* from f where not exists t2.实例select f.* from (select shopsellst.Shopsellheadid,shopsell.shoppeid,shopsell.selldat... 阅读全文