SQLite 3.27

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

CREATE TABLE comparison (min REAL, STK_CODE INTEGER);
✓
INSERT INTO comparison (min, STK_CODE) VALUES
(0.0, 391301), (11.56, 391301), (7.1, 391301), 
(0.1, 391302), (0.2, 391302), 
(0.0, 391303);
✓
SELECT rowid
FROM comparison
GROUP BY STK_CODE
HAVING (COUNT(*) = 1 OR MIN(CASE WHEN min > 0 THEN min END))


rowid


3

4

6


DELETE FROM comparison
WHERE rowid NOT IN (
  SELECT rowid
  FROM comparison
  GROUP BY STK_CODE
  HAVING (COUNT(*) = 1 OR MIN(CASE WHEN min > 0 THEN min END))
)
✓
SELECT * FROM comparison


min
STK_CODE


7.1
391301

0.1
391302

0
391303