How to select distinct rows group by
Hello GuysI got a table like
id, date, message
With a lot of messages per day
I need to select distinct message per day, not per date.
Do you guys see a nice SQL for that?
Best regards
Fredrik
MAN Energy Solutions
Senior Digital and AI Product OwnerKyocera Unimerco
BI Developer med speciale i Power BIVisma DataLøn og ProLøn
System DeveloperBunker Holding A/S
Senior CRM DevelopersKMD A/S
Head of DevelopmentI går 16:03 | Låne / købe "Annie get your gun" - 1950 (Betty Hutton & Howard Keel) Soundtrack. Af Ikke-ekspert i Fri debat |
I går 15:45 | Søgning på tlf.nr. Af Hunfling i Mobiltelefoner |
I går 09:34 | Word VBA: Check engelsk gramma og ret fejl Af Dan Elgaard i Word |
29/0412:07 | fjerne rettigheder fra google drev Af lurup i Cloudtjenester |
28/0415:22 | hta - powershell eller lign. Af tjodense i Andet programmering |
Arctic Wolf
Konica Minolta
Arctic Wolf
Conscia
Sydbank
Automation Developer til Transaction BankingEvida
IT-supporterUnit IT
Senior Solutions ArchitectCapgemini Danmark A/S
Senior SAP S/4HANA Finance LeadNetcompany A/S
Managing ArchitectORTEC Nordic A/S
International Implementation ConsultantNetcompany A/S
IT ConsultantSydbank
Cyber Security SpecialistCognizant
Konica Minolta
Sabio
Arctic Wolf