Sql Query Needed
3 tables join
student table has studentid (3 students) & studentname columns
subject table has subjectid (3 subjects) & subjestname (3 names) columns
marks table has studentid, subjectid, studentname and marks columns for 3 subjects
find out students who passed based on below 2 conditions
1. SUM(marks) > 120 and
2. marks for all subjects are present and more than zero in each subject
Subject
Written By
Posted
Sql Query Needed
September 25, 2019 11:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.