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
7921 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 does db2 mean?

1017

Explain about mirror activator disk mirroring?

1011

What are the benefits of using the db2 database?

1229

Mention the downsides of page level lock.

1162

Which are the db2 tools to protect integrity of the database?

1122

What is the maximum number of columns in a db2 table?

1285

What is dbrm library?

1056

How to find the maximum value in a column in the db2 database?

1084

What is database manager in db2?

1023

Why do we need reorg in db2?

988

What does db2 blu stand for?

1166

What is the usage of open cursor command?

1100

what is utility for parm lib

2377

How is a typical db2 batch pgm executed?

1176

What are the prerogatives?

1080