Schlagwort-Archive: rank

Microsoft SQL Server: How-to realize a SQL Statement that only returns the maximum or the minimum rows of a group (similar to an non-existing aggregate function for the GROUP BY clause)

Actual situation A change request (field „pcr“) only can have one unique assigned user that shall be informed about the assignment every night. The assigned user (field „created_by“) of a change requests (field „pcr“) is changing several times a day. … Weiterlesen

Veröffentlicht unter MS SQL Server, Programmierung, SQL | Verschlagwortet mit , , , , , | Schreib einen Kommentar