[selectRecords]
select
	'1' as kbn
	, u.den_no as uri_no
	, m.row_no as uri_row
	, trunc((m.row_no)/ 5) + 1  as uri_row_kai
	, u.jucyu_no as jyucyu
	, m.jucyu_no as jyucyum
	, m.jucyu_row_no as jyucyu_row
	, case when u.input_ymd = '' then '日付を入力してください'
		else to_char(to_date(u.input_ymd,'yyyymmdd'),'yyyy/mm/dd')
		end as u_ymd
	, case u.nonyu_tan
		when '' then '御中'
		else ''
		end as keisyou_a
	, case
		when coalesce(u.nonyu_tan,'') = '' then ''
		else '様'
		end as keisyou_a2
	, u.tok_cd
	, u.tok_nm
	, m.suryo as uri_s
	, m.tanka as uri_t
	, m.kingaku as uri_g
	, u.zeinuki_gaku as zn_gaku
	, u.zei_gaku as z_gaku
	, u.zeikomi_gaku as zi_gaku
	, u.seikyu_ymd as s_ymd
	, u.nonyu_nm
	, u.nonyu_tan
	, u.nonyu_zip_no
	, u.nonyu_addr1
	, u.nonyu_addr2
	, u.nonyu_addr3
	, u.nonyu_addr4
	, u.nonyu_tel_no
	, u.nonyu_fax_no
	, t.tok_nm as tokui_nm
	, case t.keisyo
		when '' then '様'
		else t.keisyo
		end as keisyo
	, t.tok_kana as tokui_kana
	, left(t.zip_no,3)||'-'||right(t.zip_no,4) as post_n
	, t.addr1
	, t.addr2
	, t.addr3
	, m.hin_nm
	, m.meisai_biko
	, u.biko1
	, j.mst_kbn
	, j.han_cd
	, j.han_name
	, j.koumoku1
	, j.koumoku2
	, j.koumoku3
	, j.koumoku4
	, j.koumoku5
	, j.koumoku6
	, j.koumoku7
	, j.koumoku8
	, j.koumoku9
from t_uri u
	left join t_uri_m m on u.den_no = m.den_no
	left join m_tokui t on u.tok_cd = t.tok_cd
	left join m_hanyo j on (j.mst_kbn='90' and j.han_cd='jisya')
where 1=1
and u.del_flg = 0
and ((u.input_ymd >= '&1') or ('&1' = '')) 
and ((u.input_ymd <= '&2') or ('&2' = ''))
and ((cast(u.den_no as varchar(8))= '&3') or ('&3' = ''))
and ((t.tok_cd = '&4') or ('&4' = ''))
and ((m.hin_nm like '&5') or ('&5' like ''))  
order by uri_no,tok_cd,u_ymd,uri_row;




[selectRecords_OLD]
select '1' as kbn,
    u.den_no as uri_no,
    m.row_no as uri_row,
    trunc((m.row_no)/ 5) + 1  as uri_row_kai,
    u.jucyu_no as jyucyu,
    m.jucyu_no as jyucyum,
    m.jucyu_row_no as jyucyu_row,
    case when u.input_ymd = '' then '日付を入力してください'
           else to_char(to_date(u.input_ymd,'yyyymmdd'),'yyyy/mm/dd')
           end as u_ymd,
    u.tok_cd as tokui_cd,
    m.suryo as uri_s,
    m.tanka as uri_t,
    m.kingaku as uri_g,

  -- 変更
    case
        when m2.max_kai = trunc((m.row_no)/ 5) + 1 then u.zeinuki_gaku
        else null end  as zn_gaku,
    case
        when m2.max_kai = trunc((m.row_no)/ 5) + 1 then u.zei_gaku
        else null end  as z_gaku,
    case
        when m2.max_kai = trunc((m.row_no)/ 5) + 1 then u.zeikomi_gaku
        else null end  as zi_gaku,
    case
        when m2.max_kai = trunc((m.row_no)/ 5) + 1 then u.seikyu_ymd
        else null end  as s_ymd,
--    u.zeinuki_gaku as zn_gaku,
--    u.zei_gaku as z_gaku,
--    u.zeikomi_gaku as zi_gaku,
--    u.seikyu_ymd as s_ymd,

    t.tok_nm as tokui_nm,
    t.tok_kana as tokui_kana,
    left(t.zip_no,3)||'-'||right(t.zip_no,4) as post_n,
    t.addr1,
    t.addr2,
    t.addr3,
    m.hin_nm,
    m.meisai_biko,
    u.biko1
from t_uri u
    left join t_uri_m m on u.den_no = m.den_no
  -- 追加
    left join (select m3.den_no,trunc((max(m3.row_no))/ 5) + 1  as max_kai from t_uri_m m3 group by m3.den_no) m2 on m2.den_no = u.den_no

    left join m_tokui t on u.tok_cd = t.tok_cd
where 1=1
and u.jucyu_flg = 0
and u.del_flg = 0
and ((u.input_ymd >= '&1') or ('&1' = '')) 
and ((u.input_ymd <= '&2') or ('&2' = ''))
and ((cast(u.den_no as varchar(8))= '&3') or ('&3' = ''))
and ((t.tok_cd = '&4') or ('&4' = ''))
and ((m.hin_nm like '&5') or ('&5' like ''))  
order by tokui_cd,u_ymd,uri_no,uri_row;