Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 9243 Views
- I also Faced
- E-Mail Answers
Answer Posted / chidambara subbu
SELECT City FROM Customers
Group by City
HAVING COUNT(City) > 1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to view db2 table structure?
Define buffer pool.
What is nvl in db2?
Define db2 and its databases?
How to find the maximum value in a column in the db2 database?
How can you count the number of rows from a table tab?
What is image copy in db2?
How can you quickly find out the # of rows updated after an update statement?
What is catalog database in db2?
What is an instance database?
Why do we bind in db2?
How to create db2 table in mainframe?
Can you use max on a char column?
Mention the various locks that are available in db2.
What is a dbrm in db2?
