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

Answer / mahesh babu

select column_name,count(*) from table_name group by
column_name having count>1.

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

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.

What is dbrm? What it contains? When it will be created?

0 Answers  

---

What is a buffer in memory?

0 Answers  

---

Name some fields from SQLCA

1 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

Explain about cursor stability?

0 Answers  

---

Define buffer pool.

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

What is referential integrity?

5 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---