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>

Explain correlated sub-queries.

0 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

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   Cognizant,

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

How to handle null values in db2

4 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What is RUNSTATS?

3 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---