SQLite 3.27

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

CREATE TABLE tablename (`Code` TEXT, `Value` INTEGER);
INSERT INTO tablename (`Code`, `Value`) VALUES
  ('Australia', '15'),
  ('Mexico', '22'),
  ('Spain', '36'),
  ('Nigeria', '87'),
  ('Poland', '55'),
  ('Eritrea', '17'),
  ('Vietnam', '26'),
  ('Ireland', '107'),
  ('Sweden', '55'),
  ('Canada', '26');
SELECT *
FROM tablename
ORDER BY ABS(Value - (SELECT Value FROM tablename WHERE Code = 'Australia'))
LIMIT 5;


Code
Value


Australia
15

Eritrea
17

Mexico
22

Vietnam
26

Canada
26


SELECT *
FROM tablename
ORDER BY Code = 'Australia' DESC,
         ABS(Value - (SELECT Value FROM tablename WHERE Code = 'Australia'))
LIMIT 5;


Code
Value


Australia
15

Eritrea
17

Mexico
22

Vietnam
26

Canada
26