Fortlaufende Nummer innerhalb eines ResultSets
| ID | 59 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | T-SQL |
| PlGroup | Datenbank |
| PlItemTitle | Fortlaufende Nummer innerhalb eines ResultSets |
| Code | -- Beispiel: -- http://msdn.microsoft.com/de-de/library/ms186734.aspx SELECT FirstName, LastName, ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS 'Row Number', SalesYTD, PostalCode FROM Sales.vSalesPerson |
| Result Example |