/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

23 votes161 views6 answers
Create table sql
SQL
9 votes131 views2 answers
Convert data type in sql
SQL
0 vote167 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote123 views1 answer
Wordpress database query change url
SQL
8 votes122 views1 answer
Oracle find text in functions
SQL
0 vote120 views2 answers
SQL Server Standard
SQL
0 vote132 views1 answer
Sqlalchemy get ids
SQL
0 vote119 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
19 votes121 views6 answers
Sql create table
SQL
2 votes152 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL