Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL SQL insert auto insert with stop value RE: SQL insert auto insert with stop value

  • February 28, 2018 at 12:10 pm

    #1981530

    Hello Steve,

    Seems yours code is ok .

    SELECT *
    FROM (
    SELECT ROW_NUMBER()
    OVER(PARTITION BY name
    ORDER BY name DESC) AS StRank, *
    FROM [d].[dbo].[t4]) n

    Thanks