CODEWITHSUNDEEP
phpmysql
Jazuly
Jazuly

Reputation: 321

how to find minus from 2 data in mysql?

I'm using this code to find sum. I want to ask how to (-) data from total_bayaran and total_denda from this code

select nama_penerjemah, nama_projek, SUM(bayaran) AS total_bayaran, SUM(denda) AS TOTAL_denda 
FROM tbl_episode 
GROUP BY nama_penerjemah, nama_projek

For example I have data 200 and 100
so, the result will be 200-100 = 100.

Upvotes: 1

Views: 33

Answers (2)

Lokesh Kumar Gaurav
Lokesh Kumar Gaurav

Reputation: 726

You can do like this also

select nama_penerjemah, nama_projek,(Q1.total_bayaran-Q1.total_denda) total_diff from ( select nama_penerjemah, nama_projek, SUM(bayaran) AS total_bayaran, SUM(denda) AS TOTAL_denda 
FROM tbl_episode 
GROUP BY nama_penerjemah, nama_projek) Q1

Upvotes: 0

Barmar
Barmar

Reputation: 781592

Just subtract them.

SELECT select nama_penerjemah, nama_projek, 
    SUM(bayaran) AS total_bayaran, SUM(denda) AS TOTAL_denda, 
    SUM(bayaran) - SUM(denda) AS total_difference
FROM tbl_episode 
GROUP BY nama_penerjemah, nama_projek

Upvotes: 1

Related Questions