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

1 vote481 views2 answers
Thymeleaf radio button
BASIC
0 vote411 views1 answer
Basic murmur hash function
BASIC
0 vote416 views1 answer
Robocopy sync one way
BASIC
0 vote376 views2 answers
Change c code to c++ online
BASIC
0 vote370 views1 answer
Script to add value of 2 coulms of grid and show result in 3rd column
BASIC
0 vote402 views1 answer
Random numbers visual basic
BASIC
0 vote404 views1 answer
How to dynamically change the font size of a button visual basic
BASIC
0 vote464 views2 answers
Cmd cant change directory
BASIC
1 vote496 views1 answer
Itextsharp landscape a4
BASIC
0 vote426 views2 answers
Bash catch ctrl-c in a script
BASIC