/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 vote216 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote198 views1 answer
How to get mysql db size
SQL
0 vote174 views1 answer
Online sql compiler
SQL
0 vote209 views1 answer
How to output a different column name in mysql
SQL
1 vote266 views1 answer
Oracle create program if not exists
SQL
1 vote206 views1 answer
Apex run 404
SQL
0 vote222 views1 answer
Add sqlcmd to path linux
SQL
1 vote223 views1 answer
Join first name and last name sql
SQL
0 vote218 views1 answer
If column value is null then in mysql
SQL
0 vote228 views1 answer
SELECT statement to find the specific cell in database table
SQL