Interested to Buy Any Domain ? << Click Here >> for more details...
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 .
- 2 Answers
- 8043 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
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the maximum size of a char data type in db2?
What does a deadlock mean in DB2?
what is the role of the cursor in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is commit in db2?
What is host variable?
What are the prerogatives?
What is schema in db2?
What is the picture clause of null indicator variable?
What is database manager in db2?
How to connect to db2 database from windows command line?
define clustering index.
What is the difference between cursor and select statement?
