Breaking News: Grepper is joining You.com. Read the official announcement!

get next/previous record

Graceful Grouse answered on June 12, 2020 Popularity 6/10 Helpfulness 3/10

answer get next/previous record

get next/previous record

Comment

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;

Popularity 6/10 Helpfulness 3/10 Language basic

Source: stackoverflow.com

Tags: basic get record

Link to this answer
Share Copy Link