Answer / 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).

Answer / guest

Select Stud_name
From Student_Table
Where Pass_Fail = P
Group by SI

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

Which command is used to remove all rows from a table?

0 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

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

0 Answers   IBM,

---

Is db2 a mainframe?

0 Answers  

---

What is dbrm library?

0 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---