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 vote199 views2 answers
Python3 base64 encode basic authentication
BASIC
0 vote214 views2 answers
Get unique random number in vb.net
BASIC
0 vote192 views1 answer
Theme leaf concatenate
BASIC
0 vote387 views2 answers
Cmd cant change directory
BASIC
0 vote211 views1 answer
Excel vba chck that the range is empty
BASIC
0 vote203 views1 answer
Sequnce function vb.net
BASIC
0 vote413 views1 answer
Basic authentication bash
BASIC
0 vote199 views1 answer
Watch starward ascii command
BASIC
0 vote210 views1 answer
Console.OutputEncoding c#
BASIC
0 vote292 views1 answer
How to dynamically change the font size of a button visual basic
BASIC