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
Matas A/S
Technical Product Owner – CMS & DAMNetcompany A/S
Managing ArchitectKMD A/S
Test ManagerNetcompany A/S
Software DeveloperI går 22:50 | Store Mobilepay problemer Af ErikHg i Fri debat |
I går 18:36 | Valg af headset til callcenterarbejde Af Henrik Andersen i Andet hardware |
I går 15:27 | notifikationer Af gerhardpet i Chat & Messaging |
I går 11:29 | Hente data fra andet excelark VBA Af fajens i Excel |
I går 09:00 | Windows server 2025 Datacenter Af ingeman i Linux |
GlobalConnect A/S
Arctic Wolf
Kemp & Lauritzen
Arctic Wolf
KMD A/S
Contract & Vendor ManagerSolar Danmark A/S
Data EngineerBEC
Business analyst (senior)- Corporate cash poolShure Scandinavia A/S
Senior DevOps Developer with AmbitionsAktieselskabet CARL CHRISTENSEN
Vi søger en nysgerrig og skarp DataanalytikerBanedanmark
Applikationsansvarlig for Bentley IT-systemet i BanedanmarkCapgemini Danmark A/S
Experienced SAP S/4HANA consultant - Business controllingNetcompany A/S
Data Management Consultant