Group by Max not desired results in SQL ?
- Yogesh Kumar
- 04-May-2022
- 0
The last by PK row for a ContactId using top with ties
SELECT top(1) with ties *
FROM Contacts
ORDER BY row_number() over(partition by ContactID order by PK desc)
282 0
7
* Be the first to Make Comment