I've used over to create row numbers and to get the a certain row (example second row) within a group. However for getting distinct, this seems like overkill. ...