Count distinct group by SQL code?

say I had just 2 columns of data....

Postcode Sold date
LE14 6QR 01/01/2011

How could I say...display for each postcode the d开发者_StackOverflow社区ate for each time a house in that area has been sold.

E.G If that postcode occurs 14 times, it would list each of the dates?

Thanks,

---

From you description it sounds like you want to list the contents of the table, so you can do:

select Postcode, [Sold date]
from MyTable

If you do not want duplicate dates, you can do:

select Postcode, [Sold date]
from MyTable
group by Postcode, [Sold date]

---

If you're going to group then you should also COUNT just to make sure you're totals are adding up.

SELECT PostCode, [Sold Date], COUNT(PostCode)
FROM [table]
GROUP BY PostCode, [Sold Date]
ORDER BY COUNT(PostCode) DESC

---

I think this is what you want:

SELECT PostCode, SoldDate
FROM YourTable
Group By PostCode