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 vote249 views1 answer
Visual basic constructor
BASIC
0 vote238 views2 answers
Cmd cant change directory
BASIC
0 vote162 views1 answer
Resttemplate authorization basic
BASIC
0 vote230 views1 answer
How to remove characters from the end of a string visual basic
BASIC
1 vote234 views1 answer
How to add basic authentication on haproxy backend server
BASIC
0 vote160 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC
0 vote157 views1 answer
Visual basic excel freeze first row
BASIC
0 vote171 views2 answers
Get unique random number in vb.net
BASIC
0 vote156 views1 answer
Microsoft Flight Simulator.
BASIC
0 vote152 views4 answers
Online c++ to c converter
BASIC