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][1] i want to find the ratio of the two number 1200 and 600. Can anyone please help me in this regard? [1]: /storage/temp/241\untitled.gif
(comments are locked)

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

Hi,
i need the ratio of the two numbers 1200 and 600 in row 1 and 2. The ratio needs to be displayed in a new column after the column with heading "Count".
The ratio of 1200 and 600 will be 2:1 and it needs to be displayed after the count. I have function to find the ratio of the two numbers. but since i dont want to use function i want to find the ratio using the normal mathematical calculations if possible.