- Home /

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

\untitled.gif
(10.9 kB)

Comment

what does the ratio refer to? What is it the ratio of, to?

Karthik, you have edited your question (and removed the example output), but still not fully explained how you want to find the ratio. Given the data above, what result are you expecting?

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.

**Answer** by Kev Riley
·
Jun 15, 2012 at 12:23 PM

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

Using a index in a query 3 Answers

T-SQL Query Help 0 Answers

Avoid cross join when using distance function 0 Answers

How to select decimal record in a table 3 Answers

SQL Stored Procedure 1 Answer

Copyright 2018 Redgate Software. Privacy Policy

- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Ask SSC Site Issues (meta-askssc)
- Explore
- Topics
- Questions
- Users
- Badges