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 vote383 views1 answer
Visual basic constructor
BASIC
0 vote195 views1 answer
Script to add value of 2 coulms of grid and show result in 3rd column
BASIC
0 vote212 views1 answer
How to capture link cefsharp
BASIC
0 vote182 views1 answer
How to close form in vb.net
BASIC
0 vote217 views1 answer
Vb.net printing set page size
BASIC
0 vote384 views1 answer
Curl with basic auth
BASIC
0 vote188 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
2 votes373 views1 answer
Mongodb command remove by _id
BASIC
0 vote222 views1 answer
Hello world in basic
BASIC
1 vote397 views1 answer
How to make vbs error message box
BASIC