Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5847 Views
- UST, I also Faced
- E-Mail Answers
Answer / raja_kb
SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Define predicate?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is DYNSLT keyword? How do you perform selection using DYNSLT
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,
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What's The Error Code For Unique Index Voilation?
What does DSNDB07 database do?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Is ibm db2 free?
is there any restrictions for unions ?
Give the COBOL definition of a VARCHAR field.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
COBOL 
