On 03/09/2012 18:42, Robert Buckley wrote:
> This works ok
> SELECT round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From
> energie.tennet_auswertung_2010)),2) FROM energie.tennet_auswertung_2010
>
> but this does not
>
> update energie.tennet_auswertung_2010 set "Test"=
> (
> SELECT round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From
> energie.tennet_auswertung_2010)),2) FROM energie.tennet_auswertung_2010
> );
>
> ?????????
Define "works". What do you expect to get, and what so you actually get?
We can't read your mind. :-)
Also, please don't top-post - thanks.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie