sql server programming: Something like this

SELECT ColA, ColB, COUNT(*) AS [Count]
FROM mytable
GROUP BY ColA, ColB
HAVING COUNT(*)>1

Hi Sarah,

SELECT ColA, ColB, COUNT(*)
FROM SomeTable
GROUP BY ColA, ColB


Filtering:

SELECT ColA, ColB, COUNT(*)
FROM SomeTable
GROUP BY ColA, ColB
HAVING COUNT(*) > 1


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi

I want to return all records from a table and include a group count. For
example

ColA, ColB, Count as
P100, AB1, 1
P100, AB2, 2
P100, AB3, 3
P200, BB1, 1
P300, AB1, 1
P400, AB1, 1
P400, AB1, 2

I would then somehow like to filter out any records where the count is 1.

For example

ColA, ColB, Count as
P100, AB2, 2
P100, AB3, 3
P400, AB1, 2

Can anyone help me please? Many thanks

Sarah