/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

8 votes299 views2 answers
Default sql server port
SQL
1 vote287 views1 answer
Mysql select row max date
SQL
1 vote290 views1 answer
Oracle plan hash value
SQL
1 vote256 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
1 vote216 views1 answer
Alter user mysql native password
SQL
0 vote277 views1 answer
Learnxinyminutes sql
SQL
0 vote246 views1 answer
Postgresql conectar
SQL
2 votes243 views1 answer
Import database in mysql command line xampp
SQL
1 vote208 views1 answer
Oracle character set
SQL
0 vote267 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL