sql

maiguang

浏览: 262494 次
性别:
来自: 焦作

最近访客更多访客>>

xuyongff

east_zyd_zhao

nosuchperson

yangheqingvip

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

sybase

SQL C C++C#

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

分享到：