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

Where do you specify them?

1267

What is netezza database?

1018

How can you count the number of rows from a table tab?

1086

What is sqlca’s maximum length?

1176

What is dbrm in db2 database?

1105

Define db2 and its databases?

1052

What happens in bind step in a db2 program?

964

What is the reason behind not using select * in embedded sql programs?

1105

What is a trigger in the db2 database?

1067

How do you find the maximum value in a column in db2?

1096

How to fetch the last row from the table in SQL (db2)?

1650

Explain about mirror activator disk mirroring?

1003

How does a cursor work?

979

What is db2 stogroup?

1154

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1079