HOW TO SUM MULTIPLE ALIAS COLUMN

[akbar maulana]

# Table name: account_monthly_anomalies

#

#  id                 :integer          not null, primary key

#  bank_account_id    :integer

#  month              :string

#  values_in_normal   :boolean

#  values_out_normal  :boolean

#  volumes_in_normal  :boolean

#  volumes_out_normal :boolean

#  created_at         :datetime         not null

#  updated_at         :datetime         not null

saya sulit menjelaskannya tapi logiknya seperti ini

if month = '01' and values_in_normal = false then 1 else 0 AS column1

if month = '01' and values_out_normal = false then 1 else 0 AS column2

SUM(column1, column2) AS count

bagaimana ya guys ngequerynya ?

kalau pakai logik diatas, selalu muncul error column1, column2 does not exist

[Natali Ardianto]

Kalau pakai logic anda:

_____________________________

SELECT column1, column2, (column1 + column2) as COUNT

FROM (

    SELECT 

if(month = '01' and values_in_normal = false, 1, 0) AS column1,

if(month = '01' and values_out_normal = false, 1, 0) AS column2

FROM `account_monthly_anomalies` WHERE 1

) table_a

_____________________________

Tapi ini implikasinya full table scan.

[akbar maulana]

yare yare, thanks bro saya coba test dlu

[akbar maulana]

thanks brada akhirnya bisa!! thanks advance

On Wednesday, December 12, 2018 at 8:29:06 PM UTC+7, Natali Ardianto wrote: