% total of columns

[gardan06]

I want my table to view percentages. Here's how:

 

Name        Qty              Pct Qty

John                  10                10%

...

Kerry                2                    2%

__________________________________

                        100                100%

I want "Pct Qty" to automatically compute the percent of the "Qty" by the formula (qty/total qty)*100.

 

is it possible ?

 

thanks.

[Barand]

SELECT a.name, a.qty, a.qty*100/x.tot as pc

FROM tablename a

JOIN (select SUM(qty) as tot from tablename) as x

[gardan06]

SELECT a.name, a.qty, a.qty*100/x.tot as pc

FROM tablename a

JOIN (select SUM(qty) as tot from tablename) as x

amazing!

 

thanks a lot!