SQL-statement

Hi !

I have a table (TableA) showing statitics of number of lines on my salesorders. The table has 2 fields (Lines and qty)

In this example, i have 10 salesorders.

4 of them have 1 line.
4 of them have 2 lines.
2 of them have 5 lines.

I want to make a script, that looks like this:

Lines Qty Percent Accumulated percent

----- --- ------- -------------------
1     4   40      40
2     4   40      80
5     2   20      100

Is this posible with an SQl-statement ?

Regards,
Ole Received on Thu Sep 01 2005 - 00:18:51 CDT