FAANG Tutors

nav profile

Your Performance

Account Setting

Logout

  1. Lorem Ipsum is simply dummy text of the printing and typesetting industry
  • Algorithm

    Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley.

    SELECT
    COUNT(*) AS counts
    FROM seat
  • MySQL
    SELECT
    (CASE
    WHEN MOD(id, 2) != 0 AND counts != id THEN id + 1
    WHEN MOD(id, 2) != 0 AND counts = id THEN id
    ELSE id - 1
    END) AS id,
    student
    FROM
    seat,
    (SELECT
    COUNT(*) AS counts
    FROM
    seat) AS seat_counts
    ORDER BY id ASC;

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s.

When an unknown printer took a galley of type and scrambled it to make a type specimen book.

Comments 1,392

profile

John Doi

Sep 13, 2022 / 11:17 pm

SELECT (CASE WHEN MOD(id,2)=1 AND id!=(SELECT COUNT(*) FROM seat) THEN id+1 WHEN MOD(id,2)=0 THEN id-1 ELSE id END)id, student FROM seat ORDER BY 1
79
19
Show 3 replies
Reply
Share
profile

John Doi

Sep 13, 2022 / 11:17 pm

SELECT (CASE WHEN MOD(id,2)=1 AND id!=(SELECT COUNT(*) FROM seat) THEN id+1 WHEN MOD(id,2)=0 THEN id-1 ELSE id END)id, student FROM seat ORDER BY 1
79
19
Show 3 replies
Reply
Share

STATUS_200 AGENCY

Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.