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 vote329 views1 answer
Whats up
BASIC
0 vote345 views4 answers
Online c++ to c converter
BASIC
0 vote345 views1 answer
API Key Authentication, Basic , Pasword Grant, Client Credentials
BASIC
0 vote333 views1 answer
Wussup
BASIC
1 vote370 views1 answer
How to make vbs error message box
BASIC
0 vote317 views1 answer
Dos assign command output to variable (when output is of multiple lines)
BASIC
0 vote382 views1 answer
Visual basic constructor
BASIC
0 vote354 views1 answer
Theme leaf concatenate
BASIC
1 vote364 views4 answers
C code to java converter
BASIC
0 vote378 views1 answer
Detailview with form mixing
BASIC