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 vote134 views4 answers
Online c++ to c converter
BASIC
0 vote174 views1 answer
Curl with basic auth
BASIC
0 vote130 views1 answer
How to close form in vb.net
BASIC
0 vote122 views1 answer
Microsoft Flight Simulator.
BASIC
1 vote149 views4 answers
C code to java converter
BASIC
0 vote169 views1 answer
Visual basic how to dynamically change a button to bold
BASIC
0 vote135 views1 answer
Console.OutputEncoding c#
BASIC
1 vote173 views1 answer
Itextsharp landscape a4
BASIC
0 vote196 views1 answer
Visual basic how to create a dynamic button
BASIC
-1 vote122 views4 answers
C++ code to c code converter
BASIC