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 vote155 views1 answer
Whatv are additional library files in c
BASIC
1 vote228 views4 answers
C code to java converter
BASIC
1 vote233 views2 answers
Install chrome
BASIC
0 vote155 views1 answer
Visual basic how to determine if an array already contains an item
BASIC
0 vote148 views1 answer
What to include in basic C
BASIC
0 vote159 views1 answer
Excel vba chck that the range is empty
BASIC
0 vote225 views1 answer
How to remove characters from the end of a string visual basic
BASIC
0 vote252 views1 answer
Basic authentication bash
BASIC
0 vote242 views1 answer
VBA Initialise/Initialize String/Number Array (not variant)
BASIC
0 vote157 views1 answer
Script to add value of 2 coulms of grid and show result in 3rd column
BASIC