SQL Division

[IAMINFO]

Hello everyone

I am not sure how to proceed. I would like
to divide recidivism / releaseDate


select count(*) from recidivism
select count (*) from releaseDate

Thank you for helping if you can.

 

[r937]

SELECT ( select count(*) from recidivism )
     / ( select count (*) from releaseDate )

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[markros]

declare @Cnt1 int, @cnt2 int

select @cnt1 = count(*) from recidivism

select @cnt2 = count (*) from releaseDate

select coalesce(cast(@cnt1/nullif(@cnt2,0) as decimal(19,4)),0) as FinalResult, @cnt1 as Count1, @cnt2 as Count2

 

[IAMINFO]

thanks for helping, i need to elaborate

my count from recidivism is 43258
my count from released is 38422

I need to return the percentage

43258 is what percent of 38422

Thanks again

 

[r937]

SELECT 100.0 
     * ( select count(*) from recidivism )
     / ( select count(*) from releaseDate ) AS percent

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[markros]

Multiple my code by 100.00 if you want to get percentage.