maiguang 发表于 2013-1-27 04:42:46

sql

select * from fx_dandingkan where dinghu_id in( SELECT dinghu_id  FROM "DBA"."Fx_dinghu" where kanwu_id=0 and
nian=2008)
 
 
select dDing_Number from fx_dandingkan where dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and
nian=2008) and dk_shu<=9 and dj_shu>=9
 
 
select dDing_Number as "本数" from fx_dandingkan where dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0
and nian=2008) and dk_shu<=9 and dj_shu>=9 group by dding_number
order by dDing_Number ASC
 
 
select dDing_Number as "本数",count(dDing_Number) as "件数合计" from fx_dandingkan where dinghu_id in( SELECT dinghu_id FROM
"DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008) and dk_shu<=9 and dj_shu>=9 group by dding_number
order by dDing_Number ASC
 
 
select a.dDing_Number as "港台本数", count(a.dDing_Number) as "港台件数合计" from fx_dandingkan as a where
a.dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008 and city_id  in (32,34,41)) and
a.dk_shu<=9 and a.dj_shu>=9  group by a.dding_number
order by a.dDing_Number ASC
 
 
select b.dDing_Number as "本数", count(b.dDing_Number) as "件数合计" from fx_dandingkan as b where b.dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008 and city_id not in (32,34,41)) and
b.dk_shu<=9 and b.dj_shu>=9  group by b.dding_number
order by b.dDing_Number ASC
 
 
select dDing_Number as "本数",
(select count(c.dDing_Number) as "港台件数合计" from fx_dandingkan as c where
c.dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008 and city_id  in (32,34,41)) and
c.dk_shu<=9 and c.dj_shu>=9 and   c.dDing_Number=a.dDing_Number
),(
select count(b.dDing_Number) as "件数合计" from fx_dandingkan as b where
b.dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008 and city_id not in (32,34,41)) and
b.dk_shu<=9 and b.dj_shu>=9  and b.dDing_Number=a.dDing_Number
) from fx_dandingkan  a where dinghu_id in( SELECT dinghu_id FROM "DBA"."Fx_dinghu" where kanwu_id=0 and nian=2008)  and
a.dk_shu<=9 and a.dj_shu>=9 group by dDing_Number order by dDing_Number
页: [1]
查看完整版本: sql