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.