![]() |
Get operator of a formula
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 |
All times are GMT +1. The time now is 12:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com