DEV Community

Miss Pooja Anilkumar Patel
Miss Pooja Anilkumar Patel

Posted on • Updated on

626. Leetcode SOLUTION in mysql

# Write your MySQL query statement below
select (
    case
        when id % 2 = 0 then id - 1
        when id = (select max(id) from seat) then id
        else id + 1
    end
) as id, student
    from seat
    order by id;

Enter fullscreen mode Exit fullscreen mode

Top comments (0)