/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 vote262 views1 answer
Sqlite commands
SQL
20 votes252 views2 answers
Mysql bigint max value
SQL
8 votes262 views1 answer
Oracle search source code
SQL
0 vote282 views1 answer
Java nosql sort
SQL
0 vote281 views1 answer
Excel vba import data to sql server
SQL
-1 vote270 views5 answers
Online sql to linq generator
SQL
2 votes267 views1 answer
How to insert string variable into sqlite database
SQL
0 vote280 views1 answer
Oracle sql add column auto generated value
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote259 views1 answer
Sqlite update only if greater
SQL