how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 8472 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / mahesh babu
select column_name,count(*) from table_name group by
column_name having count>1.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the bind parameters ibm db2?
Explain what are the various isolation levels possible?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are the benefits of using the db2 database?
What is the connection string to connect to the DB2 Database ?
How can you do the explain of a dynamic sql statement?
What is dbrm? What it contains? When it will be created?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is access path in db2?
How is the value function used?
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?
What are host variables in db2?
Explain the benefits you can get from mainframe connect?
Is ibm db2 open source?
What is the function of logging in the db2 database?
