Result
Query: select * from rechnung
| RECHNUNGNR | DATUM | BEZAHLT | KUNDENR | FILNR |
|---|---|---|---|---|
| 1 | 2000-08-11 00:00:00.0 | Y | 11111 | 1 |
| 2 | 2000-08-11 00:00:00.0 | N | 15882 | 1 |
| 3 | 2000-08-11 00:00:00.0 | Y | 24537 | 1 |
| 4 | 2000-08-11 00:00:00.0 | Y | 78436 | 1 |
| 5 | 2000-08-11 00:00:00.0 | Y | 95543 | 1 |
| 6 | 2000-08-11 00:00:00.0 | N | 13451 | 2 |
| 1 | 2000-09-15 00:00:00.0 | N | 11111 | 1 |
| 2 | 2000-09-15 00:00:00.0 | Y | 22221 | 3 |
| 3 | 2000-09-15 00:00:00.0 | Y | 87654 | 4 |
| 1 | 2000-10-03 00:00:00.0 | Y | 11111 | 6 |
| 2 | 2000-10-03 00:00:00.0 | Y | 95543 | 5 |
| 1 | 2000-10-10 00:00:00.0 | N | 77777 | 5 |
| 2 | 2000-10-10 00:00:00.0 | Y | 99332 | 2 |
| 1 | 2000-10-20 00:00:00.0 | Y | 67891 | 2 |
| 2 | 2000-10-20 00:00:00.0 | N | 15882 | 3 |
| 3 | 2000-10-20 00:00:00.0 | Y | 98077 | 3 |
| 4 | 2000-10-20 00:00:00.0 | N | 78436 | 3 |
| 5 | 2000-10-20 00:00:00.0 | Y | 95543 | 5 |
| 6 | 2000-10-20 00:00:00.0 | N | 13451 | 5 |
| 1 | 2000-10-21 00:00:00.0 | Y | 87654 | 4 |
| 2 | 2000-10-21 00:00:00.0 | Y | 22221 | 4 |
| 3 | 2000-10-21 00:00:00.0 | Y | 87654 | 5 |
| 1 | 2000-10-25 00:00:00.0 | N | 13451 | 2 |
| 2 | 2000-10-25 00:00:00.0 | Y | 99332 | 1 |