开发者

simple sql query, combine results and divide

I'm trying to get 2 counts from 2 tables and work out the percentage like for a MySQL db:

  1. select field_one, count(*) as COUNT_ONE from table1 group by field_one;

  2. select other_field,count(*) as COUNT_TWO from table2 gr开发者_StackOverflow社区oup by other_field;

I want to combine the results and have FINAL_COUNT=(COUNT_ONE/COUNT_TWO) * 100 for percentage ?


quick and dirty:

select (a.count_one / b.count_two) * 100 as final_count from 
(select field_one, count(*) as count_one from table1 group by field_one) a,
(select field_two, count(*) as count_two from table2 group by field_two) b
where a.field_one = b.field_two


select sum(((QUERY FROM TABLE 1) / (QUERY FROM TABLE 2)) * 100) as percentage
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜