how to subtract of two numbers in mysql

Solutions on MaxInterview for how to subtract of two numbers in mysql by the best coders in the world

Search
showing results for - "how to subtract of two numbers in mysql"
Alberto
27 Jul 2018
1select sum(s0.w - s1.w) as total_weight_loss
2from (select idMember, max(weight) as w from Measurements m
3      where m.date = (select min(date)  from Measurements n
4                      where m.idMember = n.idMember)
5      group by idMember) s0
6join (select idMember, min(weight) as w from Measurements m
7      where m.date = (select max(date)  from Measurements n
8                      where m.idMember = n.idMember)
9      group by idMember) s1
10on s0.idMember = s1.idMember
11
source
similar questions
mysql select multiple rows into one columnmysql query single rowmysql multiple order bymysql select smaller of two valueshow to select multiple columns from different tables in mysqlmysql two column combination uniquemulti value column mysqlmysql multiple countmultiple left join mysqlmysql multiple primary keysmysql multiple set statementshow to find the top 2 unique records using mysqlmysql select inside summysql subtract number to fieldmysql subtract month from timestampquerry mysql by 2 columnsusing sum function in mysql for two diffrenet conditionshow to add multiple condition in mysql querymysql insert multiple rows based on selectmysql count multiple columns in one querymysql unique two columnsmysql multiply
queries leading to this page
subtract two numbers myqlmysql subtract numbersdo an substraction of 2 values of same row mysqlsubtract two values in mysqlhow to subtract two times in mysqlmysql subtract two valuessubstract 2 numbers mysqlhow to subtract of two numbers in mysql