Dividing SQL Results...

[cranebill]

Just experimenting with SQL and was trying something new.

How can I get the answer to this with SQL:

Select Count(*) From Table A

Divided by

Select Count(*) From Table B

to create a percentage?

I have 2 complex queries and the above is just used as examples but am trying to determine sales percentages.

Thanks

 

[ericbrunson]

select ( select count(*) from a ) / ( select count(*) from b );

You need a version of mysql that does subqueries.