Tag Info

New answers tagged

0

Here's what wound up working for me: select a.desc, count(union_all.TabA_id) as "Count of A", to_char(round(ratio_to_report(count(union_all.TabA_id)) over()*100)) || '%' as "Percentage of Total" from TabA a left join ( select TabA_id from TabC union all select TabA_id from TabB ) union_all on ...


1

I'm giving it a shot, still not sure if I got it: select 100.0*(count(b.taba_id) + count(c.taba_id)) / (( select count(1) from b) + (select count(1) from c)) from taba as a left join tabb as b on a.id = b.id left join tabc as c on a.id = c.id Some thoughts, count will newer return null so coalesce is pointless. If the above is correct it ...


0

A database table can be considered to be a logical definition (the columns and data types, name, constraints etc), and the physical implementation, which is one or more data segments where the data is stored. Normally the data segments are visible and accessible to all users who have privileges to select/insert/update the table. In a GTT however, each user ...



Top 50 recent answers are included