need help to find ratio

Question

Hi,

I need a small help from the Ask SSC members. I need to find the ratio using sql and print it in the output.

The scenario is i have a total of 1800 records and i have splitted the whole 1800 records into two portions. One part will have 1200 records with the company name a and the company name b will have remaining 600 records.

I am able to get the output in the following format

alt text

i want to find the ratio of the two number 1200 and 600.

Can anyone please help me in this regard?

Answer 1

0

If 2 in the ratio is the count of how many companies there are, then it's a simple count(*)over()

select
 CompanyName,
 count(*) as Count,
 cast(count(*)over() as varchar) +':1' as Ratio
from
 YourTable
group by
 CompanyName

answered Jun 15 '12 at 12:23 PM

Kev Riley ♦♦
46k ● 38 ● 43 ● 69

(comments are locked)

need help to find ratio

Follow this question

Related Questions