/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 vote229 views1 answer
Sql ssrs
SQL
1 vote173 views3 answers
Mysql disable foreign keys check
SQL
1 vote164 views2 answers
Mysql spring boot application.properties
SQL
0 vote174 views1 answer
How to declare variable date in mysql
SQL
4 votes182 views1 answer
Id increment ms sql server
SQL
20 votes167 views2 answers
Counting in sql
SQL
0 vote217 views1 answer
How to check rollback status in oracle
SQL
1 vote176 views1 answer
Mysql f# examples
SQL
2 votes164 views1 answer
Drop table purge
SQL
0 vote270 views1 answer
Oracle db get table sizes
SQL