asked on

SQL and percentages

I have a table that returns counts of values, on a daily basis. i.e if I have column named users this column will have total user numbers on day1, day2, day3, etc.... Is there a way to get the percentage growth using SQl, I know the math operators are limited... so if a user count on monday show 2 users, and the count on tuesday shows four users I want to calculate the percent growth, and show this value on a table, showing daliy percentage growth.....

ASKER CERTIFIED SOLUTION

ee_rlee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Alinafe

ASKER

so if my date from yesterday is 01-28-08, and todays date is 1-29-08 can I use trunc(sysdate) - trunc(sysdate - 1) to define a general date range to get the count value from day to day, to work this percentage out? I am using a Timestamp to record my days, and I have a trigger on the columns to only record values from day to day.....

Thanks

Sean Stuber

If you're using the first method yes, something like that would probably work.

again though, I highly recommend you use analytics over joins. Much, much more efficient