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
8042 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

Explain dclgen.

1274

If I have a view which is a join of two or more tables, can this view be updateable?

1187

Define db2 and its databases?

1115

What is dclgen (declaration generator)?

1119

What is the use of reorg in db2?

1140

what is the role of the cursor in db2?

1115

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3207

Which isolation level provides highest data integrity?

1190

How can the duplicate values be eliminated from db2 select?

1161

What is reorg and runstats in db2?

1262

What is the use of db2?

1115

When reorg is used?

1184

What are host variables in db2?

1125

Explain what are the various isolation levels possible?

1100

What is meant by dclgen?

1174