• Home
• com.github.javadev
• leetcode-in-java
• 1.17
• source code
• script.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

g0601_0700.s0626_exchange_seats.script.sql Maven / Gradle / Ivy

# Write your MySQL query statement below
# #Medium #Database #2022_03_21_Time_274_ms_(65.75%)_Space_0B_(100.00%)
select
    id,
    case when id % 2 = 1 and lead(student) over (order by id) is null then student 
         when id % 2 = 1 then lead(student) over (order by id)
         else lag(student) over (order by id)
    end as student
from seat
order by id asc