i want to group my results except one column:
Select Name,Title,Date from Books group by Name,Title
i don't want to group by date because books might have same date
These one is working as expected
SELECT [Name]
,[Title]
,max(Date)
FROM [Books].[dbo].[myBooks] group by [Name],[Title]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With