Select Stud_name From Student_Table Where Pass

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 .

Question Posted / guest

2 Answers
7912 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

Please Help Members By Posting Answers For Below Questions

What is the maximum size of a char data type in db2?

1010

What is dpf in db2?

1103

How can record locking be achieved in those DB2 versions which do not support it?

1074

what are bind concepts in db2 cobol?

1090

Before you give the explain statement, what are the prerogatives?

1028

Explain the function done by data manager?

1276

What is cascading rollback?

1209

How can we read records for specific member in CL? AND rpg?

694

Can we insert update delete in view?

967

What are the prerogatives?

1078

What is concurrency?

1229

Explain what are the various isolation levels possible?

1042

What is a dbrm in db2?

1020

What is db2 purescale?

993

What is an instance in db2?

1033