/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

3 votes370 views2 answers
Create schema postgres
SQL
0 vote398 views1 answer
Pl/pgsql declare variable
SQL
0 vote394 views1 answer
Mysql query with sql to get the next row
SQL
10 votes355 views2 answers
Sql merge statement
SQL
1 vote353 views2 answers
Oracle list partitioned tables
SQL
0 vote378 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
11 votes388 views4 answers
Update row in mysql
SQL
0 vote379 views1 answer
Migration graphql
SQL
0 vote349 views1 answer
Sql server convert date to weekday
SQL
11 votes394 views2 answers
How to import mysql database command line
SQL