SELECT * FROM STUDENT_TABLE WHERE SI NOT IN (SELECT DISTINCT SI FR

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 / ajmal

2 Answers
7801 Views
Cognizant, I also Faced
E-Mail Answers

Answer Posted / ajmal

SELECT *
FROM STUDENT_TABLE
WHERE SI NOT IN
(SELECT DISTINCT SI
FROM STUDENT_TABLE
WHERE PASS_FAIL = 'F'
)

The inner query will retrieve all the SI numbers for who is failed in at least 1 subject(eg: Sham). The outer query will retrieve the other student's details(eg: Ram).

Is This Answer Correct ?

19 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

define clustering index.

978

What is db2 purescale?

943

When reorg is used?

1070

What is cobol db2?

933

How do I change the column size in db2?

1082

What is the difference between db2 and oracle?

1068

Where can you declare a cursor in a cobol-db2 program?

994

What is dbrm? What it contains?

1109

How do you pull up a query which was previously saved in qmf?

1099

What are union and union all?

920

can all users have the privilage to use the sql statement select * (dml)?

1102

What is role in db2?

1040

List down the types of triggers in the db2 database?

962

What is a storage group (stogroup)?

1189

What does a deadlock mean in DB2?

1094