Answer / nans

Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;

Answer / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Answer / mahesh vasudevan

Select <col-name> from table A1 and A2
where A1.Col = A2.Col.

This should be an inner join. Then you are finding the
intersection of the key values...if you want to find the
duplicates for all matching column of the rows code AND
condition for join with all those columns.....by the way
there are different easy ways to find it. but this is one of
the way.

Answer / pandu

select distinct from <field name> from <table name>

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What are foreign keys?

1 Answers  

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is meant by index cardinality?

2 Answers  

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

Which isolation level provides highest data integrity?

0 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What is a trigger in the db2 database?

0 Answers  

---

What is a lock?

1 Answers  

---