/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 vote345 views2 answers
Select last 30 days sql
SQL
0 vote301 views1 answer
10000000000000000000 am to meters
SQL
16 votes335 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes323 views1 answer
Scaffold npgsql net core
SQL
6 votes281 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote329 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote315 views1 answer
Except in sql
SQL
1 vote323 views1 answer
Right outer vs left outer join
SQL
1 vote314 views1 answer
Sqlite show columns in table
SQL
0 vote307 views2 answers
How to find max and min salary in sql
SQL