ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get operator of a formula (https://www.excelbanter.com/excel-programming/454554-get-operator-formula.html)

[email protected]

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