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

1 vote249 views1 answer
How to add basic authentication on haproxy backend server
BASIC
0 vote183 views1 answer
Vb.net printing set page size
BASIC
0 vote167 views1 answer
Split to arraylist vb.net
BASIC
0 vote198 views1 answer
API Key Authentication, Basic , Pasword Grant, Client Credentials
BASIC
0 vote172 views1 answer
Resttemplate authorization basic
BASIC
0 vote263 views1 answer
Visual basic constructor
BASIC
0 vote167 views1 answer
How to dynamically change the font size of a button visual basic
BASIC
2 votes256 views1 answer
Mongodb command remove by _id
BASIC
0 vote167 views1 answer
Pmatplotlib draw a square with a magenta dotted line and pentagon markersython matplotlib overlaped
BASIC
0 vote220 views1 answer
Visual basic how to create a dynamic button
BASIC