/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 vote178 views1 answer
Mysql drop multiple tables at once
SQL
0 vote182 views1 answer
How to save data in database in mysql node
SQL
7 votes179 views1 answer
Minecraft forge server host
SQL
0 vote190 views1 answer
Mysql get longest string in column
SQL
0 vote198 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote178 views4 answers
Sql year
SQL
8 votes176 views3 answers
Oracle auto_increment
SQL
4 votes168 views1 answer
Sql group by year
SQL
0 vote195 views1 answer
Sql query interview questions githu
SQL
0 vote181 views1 answer
Test the postgresql db connection
SQL