By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
XTypeNo | Xtype | XDateTime | Xvalue |
---|---|---|---|
1 | TypeA | 2020-02-08 06:42:24.000 | 10 |
2 | TypeC | 2020-02-06 10:17:12.000 | 20 |
3 | TypeB | 2021-02-06 03:14:33.000 | 10 |
4 | TypeC | 2020-02-03 21:33:04.000 | 20 |
5 | TypeC | 2021-02-03 21:33:04.000 | 50 |
6 | TypeA | 2021-02-03 05:07:12.000 | 20 |
7 | TypeB | 2020-01-20 23:01:53.000 | 30 |
8 | TypeB | 2021-01-19 19:37:54.000 | 90 |
9 | TypeA | 2020-11-07 00:11:49.000 | 30 |
10 | TypeA | 2020-10-05 19:25:28.000 | 70 |
XTypeNo | Xtype | XDateTime | Xvalue | ID | Xtype |
---|---|---|---|---|---|
3 | TypeB | 2021-02-06 03:14:33.000 | 10 | 1 | TypeB |
8 | TypeB | 2021-01-19 19:37:54.000 | 90 | 1 | TypeB |
7 | TypeB | 2020-01-20 23:01:53.000 | 30 | 1 | TypeB |
5 | TypeC | 2021-02-03 21:33:04.000 | 50 | 2 | TypeC |
2 | TypeC | 2020-02-06 10:17:12.000 | 20 | 2 | TypeC |
4 | TypeC | 2020-02-03 21:33:04.000 | 20 | 2 | TypeC |
6 | TypeA | 2021-02-03 05:07:12.000 | 20 | 3 | TypeA |
9 | TypeA | 2020-11-07 00:11:49.000 | 30 | 3 | TypeA |
10 | TypeA | 2020-10-05 19:25:28.000 | 70 | 3 | TypeA |
1 | TypeA | 2020-02-08 06:42:24.000 | 10 | 3 | TypeA |
XTypeNo | Xtype | XDateTime | Xvalue |
---|---|---|---|
3 | TypeB | 2021-02-06 03:14:33.000 | 10 |
8 | TypeB | 2021-01-19 19:37:54.000 | 90 |
7 | TypeB | 2020-01-20 23:01:53.000 | 30 |
5 | TypeC | 2021-02-03 21:33:04.000 | 50 |
2 | TypeC | 2020-02-06 10:17:12.000 | 20 |
4 | TypeC | 2020-02-03 21:33:04.000 | 20 |
6 | TypeA | 2021-02-03 05:07:12.000 | 20 |
9 | TypeA | 2020-11-07 00:11:49.000 | 30 |
10 | TypeA | 2020-10-05 19:25:28.000 | 70 |
1 | TypeA | 2020-02-08 06:42:24.000 | 10 |