By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE
CREATE TABLE
INSERT 0 5
| filename | ?column? |
|---|---|
| Sample1.txt | 1 |
| Sample2.txt | 2 |
| Sample3.txt | 1 |
| Sample1.txt | 3 |
| Sample4.txt | 1 |
SELECT 5
DROP TABLE
CREATE TABLE
INSERT 0 5
| filename | ?column? |
|---|---|
| Sample1.txt | 1 |
| Sample2.txt | 2 |
| Sample3.txt | 1 |
| Sample1.txt | 3 |
| Sample4.txt | 1 |
SELECT 5