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 vote330 views3 answers
JWT EM VBNET
BASIC
0 vote316 views1 answer
Vb.net printing set page size
BASIC
0 vote308 views2 answers
Change c code to c++ online
BASIC
0 vote326 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote358 views2 answers
Bash catch ctrl-c in a script
BASIC
0 vote346 views2 answers
Get unique random number in vb.net
BASIC
0 vote417 views1 answer
Visual basic how to create a dynamic button
BASIC
0 vote357 views6 answers
C++ to c converter online
BASIC
2 votes353 views1 answer
How to send basic auth using fetch
BASIC
0 vote316 views1 answer
Watch starward ascii command
BASIC