SELECT *
FROM STUDENT as s1
JOIN  STUDENT as s2
on s1.id=s2.id
WHERE s1.room_id=8
and s1.id!=1

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter