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 .
- 2 Answers
- 6852 Views
- Cognizant, I also Faced
- E-Mail Answers
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
How to execute stored procedure in db2 command editor?
What is plan in cobol db2?
What is the connection string to connect to the DB2 Database ?
What is the reason behind not using select * in embedded sql programs?
What is the difference between using bind () and rebind () methods of naming class?
What is universal database?
What is load utility in db2?
Explain about rct in db2?
What does db2 blu stand for?
What does db2 mean?
Define data page.
What is schema in db2?
What is bind and rebind in db2?
What is db2 purescale?
What is netezza database?
