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
7934 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 use of dclgen in db2?

1093

How do I start db2 in windows?

1108

What is the max length of sqlca?

1230

Mention some fields that are a part of sqlca.

1052

What is db2 purescale?

1014

List down the types of triggers in the db2 database?

1040

Is db2 a mainframe database?

1013

How is the value function used?

1163

What is the default page size of buffer pools?

1131

List down the data types in the db2 database.

1135

Explain the function of data manager.

1052

When the like statement is used?

1234

What is the picture clause of null indicator variable?

1145

How and when does the db2 enforces the unique key?

1089

Define declaration generator (dclgen).

1124