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
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is difference between rollback and commit?
What is null indicator in cobol db2?
What is bind plan?
What is the reason behind not using select * in embedded sql programs?
How does cobol compile db2 program?
What are bind parameters in db2?
What is the role of data manager in the db2 database?
How to find primary key of a table in db2?
What is db2?
what is a corelated subquerry?
What is the use of db2 optimizer?
What is nvl in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is innodb buffer pool?