Display only Values in colums from output

[Ankur Kaushik]

Below is Query

select schedule_no,
CASE WHEN weekday1=0 THEN weekday ELSE 0 END Monday,
CASE WHEN weekday1=1 THEN weekday ELSE 0 END Tue,
CASE WHEN weekday1=2 THEN weekday ELSE 0 END Wed,
CASE WHEN weekday1=3 THEN weekday ELSE 0 END Thu,
CASE WHEN weekday1=4 THEN weekday ELSE 0 END Fri ,
CASE WHEN weekday1=5 THEN weekday ELSE 0 END Sat,
CASE WHEN weekday1=6 THEN weekday ELSE 0 END Sun
from
(SELECT SUM(`px_total_amount`),schedule_no,concat(DAYNAME(ticket_date), FLOOR((DayOfMonth(ticket_date)-1)/7)+1) weekday,ticket_date,WEEKDAY(ticket_date) weekday1 FROM `ticket` WHERE `ticket_date` between '2017-01-01' and '2017-01-15' AND ticket_no!=0 AND ticket_printed_flag='Y' AND schedule_no='111/2' AND fare_type Not IN ('NINC') group by schedule_no,ticket_date order by schedule_no,WEEKDAY(ticket_date))
a group by schedule_no,weekday;


+-------------+---------+----------+------------+---------+-----------+---------+
| schedule_no | Monday | Tue | Wed | Fri | Sat | Sun |
+-------------+---------+----------+------------+---------+-----------+---------+
| 111/2 | 0 | 0 | 0 | 0 | 0 | 0 |
| 111/2 | 0 | 0 | 0 | 0 | 0 | Sunday1 |
| 111/2 | 0 | 0 | 0 | 0 | 0 | Sunday2 |
| 111/2 | 0 | 0 | 0 | 0 | 0 | Sunday3 |
| 111/2 | 0 | 0 | 0 | 0 | Saturday1 | 0 |
| 111/2 | 0 | 0 | 0 | 0 | Saturday2 | 0 |
| 111/2 | 0 | 0 | 0 | Friday1 | 0 | 0 |
| 111/2 | 0 | 0 | 0 | Friday2 | 0 | 0 |
| 111/2 | 0 | 0 | Wednesday1 | 0 | 0 | 0 |
| 111/2 | 0 | 0 | Wednesday2 | 0 | 0 | 0 |
| 111/2 | 0 | Tuesday1 | 0 | 0 | 0 | 0 |
| 111/2 | 0 | Tuesday2 | 0 | 0 | 0 | 0 |
| 111/2 | Monday1 | 0 | 0 | 0 | 0 | 0 |
| 111/2 | Monday2 | 0 | 0 | 0 | 0 | 0 |
+-------------+---------+----------+------------+---------+-----------+---------+


Require Output of only Values ....


+-------------+---------+----------+------------+---------+-----------+---------+
| schedule_no | Monday | Tue | Wed | Fri | Sat | Sun
+-------------+---------+----------+------------+---------+-----------+---------+
| 111/2 | Monday1 | Tuesday1 | Wednesday1 | Friday1 | Saturday1 | Sunday1
| 111/2 | Monday2 | Tuesday2 | Wednesday2 | Friday2 | Saturday2 | Sunday2
| 111/2 | null | null | null | null | null| Sunday3