how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9118 Views
- ANZ, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anshuman
Select column_name1,column_name2
from table_T
group by column_name1 having count(*)>1
it will give all the duplicates value of column_name1
| Is This Answer Correct ? | 28 Yes | 7 No |
Answer / mahesh babu
select column_name,count(*) from table_name group by
column_name having count>1.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / naresh k
select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name
| Is This Answer Correct ? | 0 Yes | 15 No |
Answer / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
| Is This Answer Correct ? | 2 Yes | 26 No |
how will you retrieve first record in table
What is RUNSTATS?
How will fetch last 5 rows from table in db2
What is a bind in db2?
What is db2 command?
What is null indicator in db2?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What are data types?
How do you insert a record with a nullable column?
List some fields from sqlca?
how 2 resolve the -311 sqlcode
How to resolve -818 sql code in DB2?
COBOL 
