By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Type | Quality | FldOrLab | PID | sample_date | sample_time | RowOrder |
|---|---|---|---|---|---|---|---|
| 12345MSD | SD | WQ | Lab | 12345 | 03/28/2023 | 08:16 | 1 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/28/2023 | 09:38 | 2 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/29/2023 | 07:46 | 1 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/29/2023 | 08:26 | 3 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/30/2023 | 08:24 | 3 |
| ID | Type | Quality | FldOrLab | PID | sample_date | sample_time | RowOrder |
|---|---|---|---|---|---|---|---|
| 12345MSD | SD | WQ | Lab | 12345 | 03/28/2023 | 08:16 | 1 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/28/2023 | 09:38 | 2 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/29/2023 | 07:46 | 3 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/29/2023 | 08:26 | 4 |
| 12345MSD | SD | WQ | Lab | 12345 | 03/30/2023 | 08:24 | 5 |