/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

16 votes153 views1 answer
Mysql reset auto increment value
SQL
0 vote162 views1 answer
Postgres copy command
SQL
1 vote177 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
7 votes155 views1 answer
Mysql iif
SQL
11 votes185 views2 answers
Set default column value sql
SQL
6 votes158 views2 answers
Mysql execute file
SQL
1 vote175 views1 answer
Select inside insert query
SQL
0 vote167 views1 answer
Add mysql database to power bi web
SQL
0 vote160 views1 answer
Turnicate in mysql
SQL
1 vote178 views1 answer
Mysql show long running queries
SQL