27,582
社区成员




1.select count(*) ,belong_dist_org from t_corp where admit_main='01' and start_date=to_date('2010','yyyy-mm-dd') group by belong_dist_org
2.
1)select count(*) from t_corp where check_date between to_date('2008-03-01','yyyy-mm-dd') and to_date('2008-06-30','yyyy-mm-dd') and belong_org=1331
2)select count(*) from t_corp where check_date not between to_date('2008-03-01','yyyy-mm-dd') and to_date('2008-06-30','yyyy-mm-dd') group by belong_org having belong_org=1331
3.select a.reg_no,a.corp_name,a.oper_man_name,b.tel from t_corp a
join t_corp_other b
on a.ORG=b.ORG and a.id=b.id and a.SEQ_ID=b.SEQ_ID
where corp_name like '%化学%'
4.select count(*),corp_org from t_nyc_basic where yhk_year>2009 group by corp_org
1、
select belong_dist_org,count(*) 个数 from t_corp
where admit_main='01' and left(start_date,4)='2008'
group by belong_dist_org
2、 没明白意思。那个字段是年检字段。
3、select a.reg_no,a.corp_name,a.oper_man_name,b.tel from t_corp a
join t_corp_other b
on a.ORG_ID=b.ORG_ID and a.SEQ_ID=b.SEQ_ID
where corp_name like '%化学%'
4、没看到年检表