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 vote507 views1 answer
Basic authentication bash
BASIC
0 vote414 views1 answer
What to include in basic C
BASIC
0 vote462 views5 answers
Dos assign carriage return to variable
BASIC
0 vote408 views1 answer
Resttemplate authorization basic
BASIC
0 vote486 views2 answers
Cmo ler o dado de um cliente ftp usando vbnet
BASIC
0 vote510 views1 answer
Add firefox
BASIC
1 vote461 views4 answers
C code to java converter
BASIC
0 vote438 views1 answer
Theme leaf concatenate
BASIC
0 vote445 views1 answer
Dos assign command output to variable (when output is a single line)
BASIC
0 vote498 views1 answer
Loop inner fiter()
BASIC