/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 vote214 views2 answers
Avg() sql
SQL
3 votes240 views1 answer
Fk in insert mysql
SQL
-1 vote247 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote254 views1 answer
.sql File Run in PSQL
SQL
57 votes350 views6 answers
Sql alter table
SQL
0 vote192 views1 answer
Oracle sql developer script output limit
SQL
5 votes231 views1 answer
Oracle sysdate
SQL
-1 vote258 views1 answer
Utf8_encode mysql
SQL
1 vote267 views1 answer
Liquibase alter column type / length
SQL
11 votes246 views2 answers
Mysql set safe mode off
SQL