Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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...

Question Posted / prakash5a


how will i display the duplicate record's from a table... i don't want to eliminate ...i ..

Answer / raja_kb

SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More DB2 Interview Questions

Why do we need reorg in db2?

0 Answers  

Is ibm db2 free?

0 Answers  

how can we find nth max salary from A table

5 Answers   IBM,

How can you display the current date & current time ?

1 Answers   Cap Gemini,

What is collection in db2 bind?

0 Answers  

what is difference between Plan and Package

1 Answers   Syntel,

When do you specify the isolation level? How?

1 Answers  

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

Explain correlated sub-queries.

0 Answers  

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

What is the difference between nvl and coalesce?

0 Answers  

What are foreign keys?

1 Answers  

For more DB2 Interview Questions Click Here
Categories