By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
tID | tDate | tName | tType | tAction |
---|---|---|---|---|
1 | 2019-02-01 | Bob | a | Create |
6 | 2019-02-06 | Bob | a | Delete |
7 | 2019-02-07 | Bob | a | Create |
5 | 2019-02-05 | Bob | b | Create |
9 | 2019-02-09 | Bob | b | Delete |
10 | 2019-02-10 | Bob | b | Create |
2 | 2019-02-02 | Frank | a | Create |
4 | 2019-02-04 | Frank | a | Delete |
8 | 2019-02-08 | Frank | b | Create |
3 | 2019-02-03 | Jim | b | Create |
11 | 2019-02-11 | kate | a | Create |
12 | 2019-02-12 | kate | a | Delete |
tID | tDate | tName | tType | tAction |
---|---|---|---|---|
3 | 2019-02-03 | Jim | b | Create |
7 | 2019-02-07 | Bob | a | Create |
8 | 2019-02-08 | Frank | b | Create |
10 | 2019-02-10 | Bob | b | Create |