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 vote191 views1 answer
Remove button selection outline visual basic
BASIC
0 vote194 views1 answer
Excel vba chck that the range is empty
BASIC
0 vote198 views1 answer
New list VB
BASIC
2 votes359 views1 answer
Vb string to int32
BASIC
0 vote194 views2 answers
Bash catch ctrl-c in a script
BASIC
0 vote205 views1 answer
How to capture link cefsharp
BASIC
1 vote398 views2 answers
Thymeleaf radio button
BASIC
0 vote178 views1 answer
How to close form in vb.net
BASIC
0 vote174 views1 answer
Visual basic get mouse position
BASIC
0 vote191 views1 answer
Console.OutputEncoding c#
BASIC