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 vote200 views1 answer
Trollbox
BASIC
0 vote204 views1 answer
Remove button selection outline visual basic
BASIC
1 vote401 views2 answers
Tmux basic commands
BASIC
0 vote216 views2 answers
Dos/cmd equivalent to "head"
BASIC
0 vote201 views1 answer
Powershell how to removve only empty direcoties
BASIC
0 vote194 views1 answer
Watch starward ascii command
BASIC
0 vote196 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote188 views1 answer
Random numbers visual basic
BASIC
0 vote254 views5 answers
Dos assign carriage return to variable
BASIC
0 vote203 views1 answer
JsonFileWrapper
BASIC