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 vote136 views1 answer
Xolo themeforest
BASIC
0 vote124 views1 answer
Theme leaf concatenate
BASIC
0 vote122 views1 answer
Add user to multiple groups ubuntu
BASIC
0 vote132 views1 answer
Visual basic how to determine if an array already contains an item
BASIC
0 vote180 views1 answer
Visual basic how to create a dynamic button
BASIC
0 vote76 views1 answer
How to simulate tail in dos/cmd without tail
BASIC
0 vote126 views1 answer
Random numbers visual basic
BASIC
0 vote212 views1 answer
Loop inner fiter()
BASIC
0 vote133 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote125 views1 answer
How to close form in vb.net
BASIC