I want to select all the information for today, such as a variable:
But instead of doing a new query for each, I just like Come wish:
returned Print $ ba = result; $ BB = Total number of results returned; $ BC = Total number of results returned; $ BD = Total number of results returned; How would I go about doing this?
Usage:
SELECT SUM (case when t.cat = 'BA' then 1 ELSE 0 END as BA, SM (case when t.cat = 'BB' then 1 ELSE 0 END) as BSB, SUM (case when TCAT = 'BC' then 1 ELS 0 ADD ) BSD, SM (case when TCAT = 'BD' then 1 ELSE 0 ADD) BSD from your telebali TT where '03 / 28% 'like TDT's
Comments
Post a Comment