SELECT * FROM (SELECT temp.* ,ROWNUM num FROM (select v1.company_code,
v1.full_name,
v1.security_code_a,
v1.security_abbr_a,
to_char(v1.record_date_a,'yyyy-mm-dd') record_date_a,
to_char(v1.ex_dividend_date_a,'yyyy-mm-dd') ex_dividend_date_a,
to_char(v1.dividend_per_share1_a,'9990.999') dividend_per_share1_a,
to_char(v1.dividend_per_share2_a,'9990.999') dividend_per_share2_a,
v1.exchange_rate,
to_char(v1.dividend_date,'yyyy-mm-dd') dividend_date
from mv_lc_dividendcash v1
where 1=1
AND to_char(v1.record_date_a,'yyyy')=2017
order by DIVIDEND_DATE desc nulls last ) temp ) WHERE num >50 and num <= 90;
SELECT * FROM ( SELECT temp.* ,ROWNUM num FROM ( select v1.company_code,
v1.full_name,
v1.security_code_a,
v1.security_abbr_a,
to_char(v1.record_date_a,'yyyy-mm-dd') record_date_a,
to_char(v1.ex_dividend_date_a,'yyyy-mm-dd') ex_dividend_date_a,
to_char(v1.dividend_per_share1_a,'9990.999') dividend_per_share1_a,
to_char(v1.dividend_per_share2_a,'9990.999') dividend_per_share2_a,
v1.exchange_rate,
to_char(v1.dividend_date,'yyyy-mm-dd') dividend_date
from mv_lc_dividendcash v1
where 1=1
AND to_char(v1.record_date_a,'yyyy')=2017
v1.full_name,
v1.security_code_a,
v1.security_abbr_a,
to_char(v1.record_date_a,'yyyy-mm-dd') record_date_a,
to_char(v1.ex_dividend_date_a,'yyyy-mm-dd') ex_dividend_date_a,
to_char(v1.dividend_per_share1_a,'9990.999') dividend_per_share1_a,
to_char(v1.dividend_per_share2_a,'9990.999') dividend_per_share2_a,
v1.exchange_rate,
to_char(v1.dividend_date,'yyyy-mm-dd') dividend_date
from mv_lc_dividendcash v1
where 1=1
AND to_char(v1.record_date_a,'yyyy')=2017
order by DIVIDEND_DATE desc nulls last ) temp ) WHERE num >50 and num <= 90;
SELECT * FROM ( SELECT temp.* ,ROWNUM num FROM ( select v1.company_code,
v1.full_name,
v1.security_code_a,
v1.security_abbr_a,
to_char(v1.record_date_a,'yyyy-mm-dd') record_date_a,
to_char(v1.ex_dividend_date_a,'yyyy-mm-dd') ex_dividend_date_a,
to_char(v1.dividend_per_share1_a,'9990.999') dividend_per_share1_a,
to_char(v1.dividend_per_share2_a,'9990.999') dividend_per_share2_a,
v1.exchange_rate,
to_char(v1.dividend_date,'yyyy-mm-dd') dividend_date
from mv_lc_dividendcash v1
where 1=1
AND to_char(v1.record_date_a,'yyyy')=2017
order by DIVIDEND_DATE desc nulls last ) temp where ROWNUM <= 90 ) WHERE num > 50 ;