/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 vote128 views1 answer
Update using case in mysql
SQL
1 vote164 views1 answer
How to show index type in postgresql
SQL
0 vote145 views1 answer
Sql select min
SQL
0 vote143 views1 answer
Mysql query with sql to get the next row
SQL
2 votes264 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote160 views1 answer
Mysql dump specific tables
SQL
0 vote155 views1 answer
Sql server insert inner join
SQL
0 vote130 views1 answer
Complete date is 1 year or not sql server
SQL
-1 vote137 views3 answers
Create temp table in sql
SQL
0 vote143 views1 answer
SQL: calculate hours from two dates
SQL