Search found 1 match
Search found 1 match • Page 1 of 1
- Tue Sep 21, 2021 5:17 am
- Forum: PowerPivot/DAX
- Topic: Ranking a column in one table against related occurrences [Solved]
- Replies: 2
- Views: 400
I often use Windowed Functions in the ORDER BY clause. It's super useful when I'm looking for examples in my data of frequently occurring / high number of events. For example... SELECT * FROM dbo.Episodes ORDER BY COUNT(*) OVER (PARTITION BY PatientID) desc Which will return all the rows in table Ep...