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
- 5870 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 |
What is the difference between IN subselects and EXISTS subselect?
What is buffer pool in the db2 database?
What is an intent lock?
What is dpf in db2?
What is COPY PENDING status?
What type of database is db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How will you return the number of records in table?
What is node in db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
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 is load replace in db2?
COBOL 
