SI Stud name Subject Marks Pass/Fail
1 Sham Maths 40 P
1 Sham Physics 50 P
1 Sham Bio 20 F
2 Ram Maths 40 P
2 Ram Physics 50 P
2 Ram Bio 60 P
For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Answer Posted / guest
Select Stud_name
From Student_Table
Where Pass_Fail = P
Group by SI
Is This Answer Correct ? | 6 Yes | 19 No |
Post New Answer View All Answers
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain the contention situations caused by locks?
What is the use of with ur in db2?
What is clone table?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain db2.
What is sqlca?
What is explain plan in db2?
What is the usage of open cursor command?
What does db2 stand for?
How to compare data between two tables in db2?
Is db2 a mainframe?
What does db2 blu stand for?
Mention the definition of cobol in varchar field.
How do I delete a table in db2?