By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| EmpName | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|---|
| Peter | PT200 | PT200 | PT200 | PT200 | PT200 | PT200 | PT200 |
| Sam | null | SM100 | null | SM100 | SM100 | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.