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 vote343 views1 answer
Basic murmur hash function
BASIC
0 vote372 views5 answers
Dos assign carriage return to variable
BASIC
0 vote317 views1 answer
Dos assign command output to variable (when output is a single line)
BASIC
0 vote356 views1 answer
Floppy disk drive +arduino
BASIC
0 vote308 views1 answer
Pmatplotlib draw a square with a magenta dotted line and pentagon markersython matplotlib overlaped
BASIC
0 vote312 views1 answer
NÃO CONSIGO MANDAR UM POST EM VBNET USANDO POSTMAN
BASIC
0 vote304 views2 answers
Change c code to c++ online
BASIC
0 vote358 views1 answer
How to capture link cefsharp
BASIC
0 vote371 views1 answer
Add combobox in datagridview vb.net
BASIC
0 vote327 views10 answers
Convert c program to c++ online
BASIC