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 vote175 views1 answer
JsonFileWrapper
BASIC
0 vote169 views1 answer
Watch starward ascii command
BASIC
0 vote170 views1 answer
How to simulate tail in dos/cmd without tail
BASIC
0 vote185 views2 answers
Ex:c programming
BASIC
2 votes295 views1 answer
Vb string to int32
BASIC
0 vote292 views10 answers
Convert c++ code to c online
BASIC
0 vote182 views1 answer
Detailview with form mixing
BASIC
0 vote189 views10 answers
Convert c program to c++ online
BASIC
0 vote177 views1 answer
Script to add value of 2 coulms of grid and show result in 3rd column
BASIC
0 vote175 views1 answer
Visual basic how to determine if an array already contains an item
BASIC