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
- 7806 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 syscat in db2?
What does db2 blu stand for?
What is the maximum size of varchar data type in db2?
What is schema in db2?
Mention the different locking levels that are available in db2.
What is a db2 cursor?
What is db2 stogroup?
What is the difference between nvl and coalesce?
What is host variable in db2 cobol?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Is db2 a programming language?
How do I create a view in db2?
How to connect to db2 database from windows command line?
What are the full forms of spufi and dclgen and why are they used?
