SQL Question 2: (LEFT JOIN)
Given two tables, students and students_marks, both containing student_id (primary key), student_name and students_marks tables contains marks. Display students who never appeared for exam.

Question

Sigiloso · Accepted Answer

SELECT 
    st.student_id
    st.student_name
FROM
students AS st 
LEFT JOIN students_marks AS sm
ON st.student_id = sm.student_id
WHERE sm.student_id IS NULL

Vermont Information Processing

Pergunta de entrevista da empresa Vermont Information Processing

Resposta da entrevista

Empresas seguidas

Buscas de vagas