/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

0 vote286 views1 answer
Denormalise SQL command
SQL
0 vote300 views1 answer
Sql count matching group by
SQL
0 vote295 views1 answer
Fast sql column count
SQL
0 vote244 views1 answer
Postgresql add leading zeros
SQL
0 vote324 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
2 votes287 views1 answer
Sql alchemy or
SQL
0 vote308 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote300 views4 answers
Mysql desactivar trigger
SQL
2 votes289 views1 answer
Update trigger
SQL
0 vote288 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL