Answer / gouri

select column_1 from tablename groupby column1 having coun(*)>1

Answer / chidambara subbu

SELECT City FROM Customers
Group by City
HAVING COUNT(City) > 1

Answer / sanj

say col1 is having duplicates in table tabA.Then,

select col1 from tabA
group by col1 having (count(col1) > 1)

Answer / azharuddinsyed

SELECT <COLUMN_1> FROM TABLENAME
GROUP BY COLUMN_1
HAVING COUNT(COLUMN_1) > 1

OR

SELECT <COLUMN_1> FROM TABLENAME
GROUP BY COLUMN_1
HAVING COUNT(*) > 1

List down the data types in the db2 database.

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

List out the data types available.

0 Answers  

---

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?

4 Answers   Mphasis,

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What is collection in db2 bind?

0 Answers  

---

What is meant by concurrency?

1 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

What is a LIKE table and how is it created?

2 Answers  

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---