Hi all,
I have a tabel in mysql with fld1, fld2 fl3, fld4
E export it to an Excel sheet in column
A, b, c, d

In column e the operaotr will create a formula like A1*b1/c1+SUM(A1:c5)

I have to convert again in SQL that formula as
SELECT id, fld1*fld2/fld3+(SELECT TOP 5 SUM(fld1+fld2+fld3) from mytable WHERE id= m.id) FROM mytable as m

Any suggestion?
Tks in advance
MAssimiliano