/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 vote366 views1 answer
View psql output in horizontal scrolling
SQL
0 vote350 views1 answer
Get initials name in sql
SQL
1 vote345 views1 answer
Postgresql datetrunc too slow
SQL
1 vote363 views1 answer
Liquibase alter column type / length
SQL
1 vote365 views1 answer
Mysql previous year
SQL
0 vote293 views1 answer
Kannst du deine finger trainieren
SQL
0 vote394 views1 answer
Find and replace query in wordpress\
SQL
0 vote347 views1 answer
Datetime postgres typeorm
SQL
1 vote328 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote372 views1 answer
Get last inserted primary key
SQL