/SQL/Sql server select record with max id

Sql server select record with max id

select ID , ProductCatId , ProductCode , Price
  from (
        select ID , ProductCatId , ProductCode , Price, row_number() over (partition by ProductCatId order by ID desc) as rn
         from myTable
        ) as t
  where t.rn = 1

Source: stackoverflow.com

Similar codes

1 vote141 views1 answer
Events mysql
SQL
5 votes120 views1 answer
Mysql add user with all privileges
SQL
1 vote125 views1 answer
Data type and their numeric form
SQL
3 votes135 views1 answer
Fk in insert mysql
SQL
0 vote133 views1 answer
Renombrar tabla mysql
SQL
0 vote234 views1 answer
How to use select union and loop
SQL
0 vote139 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote160 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
10 votes203 views2 answers
Doublon sql
SQL
3 votes143 views1 answer
Increment integer in table sql
SQL