/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 vote273 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote271 views1 answer
Mysql select update same table
SQL
1 vote273 views1 answer
Sql sort column by date
SQL
0 vote272 views1 answer
Inner join distinct
SQL
0 vote290 views1 answer
Postgres populate table from another table
SQL
1 vote314 views1 answer
Oracle create program if not exists
SQL
0 vote280 views2 answers
Mysql create table if not exists
SQL
6 votes273 views1 answer
Check Table Exists
SQL
2 votes257 views1 answer
Sql find missing values between two tables
SQL
0 vote307 views2 answers
Mysql missin expression near on
SQL