/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 vote195 views1 answer
Mysql count with two joins
SQL
0 vote209 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote161 views1 answer
Mariadb list tables
SQL
8 votes217 views1 answer
Declare table variable sql server
SQL
1 vote197 views1 answer
Error code 1292 mysql workbench
SQL
-1 vote213 views5 answers
Operator in sql
SQL
1 vote254 views1 answer
Sql comment header
SQL
0 vote199 views1 answer
One table with another
SQL
3 votes204 views3 answers
Raw select laravel
SQL
1 vote318 views1 answer
Adding a check statement in sql
SQL