Help for this page

Select Code to Download


  1. or download this
    create table users ( user_id integer not null primary key, name varcha
+r(16) );
...
WHERE user_id < (SELECT MAX(user_id)
                 FROM users WHERE user_id < 4) 
ORDER BY user_id DESC LIMIT 1
  2. or download this
    SELECT * 
FROM users WHERE user_id >= (SELECT MIN(user_id) 
                             FROM users WHERE user_id > 4) 
ORDER BY user_id ASC LIMIT 1