Hi All,
I have data as below - Under one header we have lines and lines can split e.g. under header 1 we see line 1 and 2 but split shows only one which means split is done for 1 line so count of lines is 2 and count of split is 1.
select ‘1’ header, ‘1’ line, ‘1’ split from dual union all
select ‘1’, ‘2’ , ‘1’ from dual union all
select ‘2’, ‘1’ , ‘1’ from dual
desired result -
line_count split_count
3 2