how to get distinct Ticket Number same date reported by two different Resources

[harish_meda]

Hi All,

can you help me on below.

I have one ticket number on same date date but two different resources like below.I need to fetch first record from the table no need to load second record.

Note:My date format as mentioned in table.I don't have timestamp