Count distinct group by SQL code?

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

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.

1 - you can't group by one column and not have an aggregation function applied to the other column. So you either need to group by both or add aggregation (i.e. MAX) for the sold date.

– judda Jun 9 at 21:53.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.