/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 vote220 views2 answers
Denormalization in sql
SQL
0 vote272 views1 answer
Get yesterday date ISO in psql
SQL
8 votes279 views1 answer
Script to add datafile to tablespace
SQL
0 vote263 views1 answer
Use between operator in mysql
SQL
4 votes274 views4 answers
What is primary key
SQL
10 votes256 views3 answers
Sql limit results
SQL
1 vote272 views1 answer
Postgres concat_ws
SQL
0 vote341 views1 answer
Python get backup of sql
SQL
0 vote271 views1 answer
Mysql set column equal to another automatic
SQL
0 vote285 views1 answer
Drop index in sql
SQL