/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 vote197 views1 answer
Postgres get database encoding
SQL
13 votes159 views2 answers
Check if value is null mysql
SQL
0 vote225 views1 answer
Mariadb used space
SQL
1 vote186 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote185 views3 answers
Psql fatal database does not exist
SQL
3 votes165 views1 answer
Oracle transaction commit rollback example
SQL
0 vote177 views1 answer
Oracle sql add column auto generated value
SQL
5 votes218 views1 answer
How to get all table names in sql query
SQL
0 vote169 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote170 views1 answer
Oracle last connection
SQL