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

2 votes274 views1 answer
How to send basic auth using fetch
BASIC
0 vote314 views1 answer
Basic latex document
BASIC
0 vote244 views2 answers
Ex:c programming
BASIC
0 vote252 views2 answers
Dos/cmd equivalent to "head"
BASIC
0 vote294 views1 answer
Hello world in basic
BASIC
0 vote258 views1 answer
Xolo themeforest
BASIC
0 vote244 views1 answer
Como colocar aspas duplas em vbnet
BASIC
0 vote272 views1 answer
Robocopy sync one way
BASIC
1 vote287 views1 answer
How to make vbs error message box
BASIC
0 vote250 views1 answer
Excel vba chck that the range is empty
BASIC