SELECT TS.GAKKO_NO AS GAKKO_NO, MG.GAKKO_NM AS GAKKO_NM, MJ.JUGYO_TNK_GAK AS JUGYO_TNK_GAK ,SUM(TS.GENNEN_SYUN_GAK) AS GENNEN_SYUN_GAK FROM TRN_SYUNO AS TS INNER JOIN MST_JUGYORYOU AS MJ ON (TS.JUGYO_NENDO_DT = MJ.JUGYO_NENDO_DT ) AND (TS.SAIKEN_TYP = MJ.SAIKEN_TYP) INNER JOIN MST_GAKKO AS MG ON (TS.GAKKO_NO = MG.GAKKO_NO) WHERE (TS.KSN_KBN = 0) AND ( ( TS.SAIKEN_TYP = '111' ) OR ( TS.SAIKEN_TYP = '112' ) ) AND ( TS.SAIKEN_NENDO_DT <='2007/04/01' ) AND TS.GENNEN_SYUN_GAK > 0 GROUP BY TS.GAKKO_NO,MG.GAKKO_NM,MJ.JUGYO_TNK_GAK ORDER BY TS.GAKKO_NO, MJ.JUGYO_TNK_GAK
请问一下怎样取得TRN_SYUNO这个表的抽出记录数?就在这段sql里面可以写吗?
请问一下怎样取得TRN_SYUNO这个表的抽出记录数?就在这段sql里面可以写吗?
每看出你什么地方用到了记录数?如果是对上面的求记录数,把查询做为子表,是这个意思吗?
select count(*) from (select ...) t
我想在这段sql把TRN_SYUNO表里抽出的记录取出来,
谢谢。
select @@rowcount--显示结果集记录---------------------放在一个执行
select * from
select @@rowcount
([color=#3366FF]SELECT TS.GAKKO_NO AS GAKKO_NO, MG.GAKKO_NM AS GAKKO_NM, MJ.JUGYO_TNK_GAK AS JUGYO_TNK_GAK , SUM(TS.GENNEN_SYUN_GAK) AS GENNEN_SYUN_GAK FROM TRN_SYUNO AS TS INNER JOIN MST_JUGYORYOU AS MJ ON (TS.JUGYO_NENDO_DT = MJ.JUGYO_NENDO_DT ) AND (TS.SAIKEN_TYP = MJ.SAIKEN_TYP) INNER JOIN MST_GAKKO AS MG ON (TS.GAKKO_NO = MG.GAKKO_NO) WHERE (TS.KSN_KBN = 0) AND ( ( TS.SAIKEN_TYP = '111' ) OR ( TS.SAIKEN_TYP = '112' ) ) AND ( TS.SAIKEN_NENDO_DT <='2007/04/01' ) AND TS.GENNEN_SYUN_GAK > 0 GROUP BY TS.GAKKO_NO,MG.GAKKO_NM,MJ.JUGYO_TNK_GAK ORDER BY TS.GAKKO_NO, MJ.JUGYO_TNK_GAK ) b
where a.GAKKO_NO= b.GAKKO_NO