Advertisement
satishfrontenddev5

Untitled

Feb 18th, 2024
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sql ques - we have two tables students and course and we have to write a query where student selected physics and math individual or both?
  2.  
  3. SELECT DISTINCT students.student_id, students.student_name
  4. FROM students
  5. JOIN course ON students.student_id = course.student_id
  6. WHERE course.course_name IN ('Physics', 'Math');
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement