create table users ( user_id integer not null primary key, name varcha +r(16) ); insert into users values (1,'Fred'); insert into users values (2,'Barney'); insert into users values (3,'Wilma'); insert into users values (4,'Betty'); insert into users values (5,'Pebbles'); SELECT * FROM usersI WHERE user_id < (SELECT MAX(user_id) FROM users WHERE user_id < 4) ORDER BY user_id DESC LIMIT 1 #### SELECT * FROM users WHERE user_id >= (SELECT MIN(user_id) FROM users WHERE user_id > 4) ORDER BY user_id ASC LIMIT 1