/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

11 votes613 views4 answers
Reset identity column values in sql server
SQL
0 vote247 views1 answer
Display all node label neo4j
SQL
5 votes221 views1 answer
Postgres integer to serial
SQL
0 vote242 views1 answer
Limit in access query
SQL
1 vote222 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote183 views1 answer
Oracle function select into
SQL
62 votes248 views8 answers
Mysql add column
SQL
0 vote276 views2 answers
Sql unique
SQL
3 votes218 views1 answer
Oracle get trigger ddl
SQL
20 votes219 views4 answers
Reset auto increment in MySQL
SQL