I have a table with a definition like this:
CREATE TABLE [dbo].[Contact] ( ClientNumber [numeric] (20, 0) NULL, ContactDate [Date] NULL, Name [text] NULL, AdditionalInformation [text] NULL )
This table is filled with information for a single month. Each client may have multiple entries for a single day. Meaning there might be entries like this:
42 2015-12-09 Felix called today 42 2015-12-09 Fexclicx ...
My goal is to get all client results from the table with the condition that there should be only one entry a day per client number. I do not care which of the (here) two entries is displayed, so something like
So far I tried to achieve this with a distinct:
select distinct ClientNumber, ContactDate, * from Contact
Unfortunately this does not limit the results to show a client entry for a specific date only once. They still all do appear. Also the problem is that there are no id's in this table so I cannot work with that.
How could I achieve getting all entries but only one entry for one client per day?