Get next/previous record

SELECT name,
       (SELECT name FROM student s1
        WHERE s1.id < s.id
        ORDER BY id DESC LIMIT 1) as previous_name,
       (SELECT name FROM student s2
        WHERE s2.id > s.id
        ORDER BY id ASC LIMIT 1) as next_name
FROM student s
    WHERE id = 7;

Source: stackoverflow.com

Mysql query with sql to get the next row

SELECT * FROM foo WHERE id = (SELECT MIN(id) FROM foo WHERE id > 4)

Source: stackoverflow.com

Similar codes

0 vote173 views6 answers
C++ to c converter online
BASIC
1 vote263 views2 answers
Thymeleaf radio button
BASIC
0 vote189 views1 answer
API Key Authentication, Basic , Pasword Grant, Client Credentials
BASIC
0 vote166 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote191 views1 answer
How to open d drive using conda prompt
BASIC
0 vote170 views1 answer
Visual basic how to determine if an array already contains an item
BASIC
0 vote234 views1 answer
Floppy disk drive +arduino
BASIC
0 vote165 views1 answer
JsonFileWrapper
BASIC
0 vote163 views1 answer
Powershell how to removve only empty direcoties
BASIC
0 vote168 views1 answer
Whatv are additional library files in c
BASIC