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
- 7082 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
What is the difference between dbm cfg and db cfg file in db2 ?
Give a brief description of db2 isolation levels?
What is bind plan?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
List some fields from sqlca?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is drop table?
What do you mean by cursor?
What is a db2 collection?
Explain in brief how does db2 determine what lock-size to use?
What action db2 takes when a program aborts in the middle of a transaction?
What is consistency token in db2?
B37 abend during spufi?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
When do you specify the isolation level?
