SQLite 3.27

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

select sqlite_version();

sqlite_version()

3.27.2

CREATE TABLE test(i int primary key, j int);

INSERT INTO test VALUES 
   (1,1),(2,1),(3,1),
   (4,2),(5,2),
   (6,3),(7,3),(8,3);
SELECT min(i),j
FROM test
GROUP BY j
ORDER BY j DESC
LIMIT 2;

min(i)
j

6
3

4
2

UPDATE test
SET j=5
WHERE j=1;
SELECT min(i),j
FROM test
GROUP BY j
ORDER BY j DESC
LIMIT 2;

min(i)
j

1
5

6
3

SELECT DISTINCT j
FROM TEST
ORDER BY i DESC
LIMIT 2;

j

3

2

SELECT j
FROM TEST
GROUP BY j
ORDER BY MIN(i) DESC
LIMIT 2;

j

3

2