SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE employee (id INTEGER PRIMARY KEY, name TEXT, savecounter INTEGER NOT NULL DEFAULT 0);
✓
INSERT INTO employee(name) VALUES
  ('name1'), ('name2'), ('name3');
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
0

2
name2
0

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 1;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
1

2
name2
0

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 2;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
1

2
name2
1

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 3;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
1

2
name2
1

3
name3
1


UPDATE employee 
SET savecounter = 0
WHERE (SELECT MIN(savecounter) FROM employee) = 1;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
0

2
name2
0

3
name3
0

`id`	`name`	`savecounter`
`1`	`name1`	`0`
`2`	`name2`	`0`
`3`	`name3`	`0`

`id`	`name`	`savecounter`
`1`	`name1`	`1`
`2`	`name2`	`0`
`3`	`name3`	`0`

`id`	`name`	`savecounter`
`1`	`name1`	`1`
`2`	`name2`	`1`
`3`	`name3`	`0`

`id`	`name`	`savecounter`
`1`	`name1`	`1`
`2`	`name2`	`1`
`3`	`name3`	`1`

`id`	`name`	`savecounter`
`1`	`name1`	`0`
`2`	`name2`	`0`
`3`	`name3`	`0`