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

Anónimo · 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

Pregunta de entrevista de Vermont Information Processing

Respuesta de la entrevista

Empresas seguidas

Búsquedas de empleo