-
Notifications
You must be signed in to change notification settings - Fork 4
LeetCode SQL 50 Solution #24
Answered
by
iamAntimPal
IamShiwangi
asked this question in
Q&A
-
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 22, 2025
# MYSQL Query Accepted
SELECT ( CASE
WHEN id%2 != 0 AND id != counts THEN id+1
WHEN id%2 != 0 AND id = counts THEN id
ELSE id-1
END) AS id, student
FROM seat, (select count(*) as counts from seat)
AS seat_counts
ORDER BY id ASC
Replies: 2 comments
-
# MYSQL Query Accepted
SELECT ( CASE
WHEN id%2 != 0 AND id != counts THEN id+1
WHEN id%2 != 0 AND id = counts THEN id
ELSE id-1
END) AS id, student
FROM seat, (select count(*) as counts from seat)
AS seat_counts
ORDER BY id ASC
Beta Was this translation helpful? Give feedback.
All reactions
-
❤️ 1
0 replies
Answer selected by
IamShiwangi
-
Thank You I understand that Question.
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment