Search found 1 match

by Trinder
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

Re: Ranking a column in one table against related occurrences [Solved]

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...

Go to advanced search