/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 vote208 views1 answer
Mysql default uuid
SQL
0 vote251 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote238 views1 answer
Nvl postgres
SQL
0 vote200 views1 answer
How to change the field size of an existing column
SQL
0 vote221 views1 answer
How to map sql column to custom names
SQL
0 vote200 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote197 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote204 views1 answer
Install mysql for fedora 34
SQL
10 votes191 views1 answer
Oracle dependency
SQL
0 vote233 views1 answer
SQL Hello, [firstname] [lastname]
SQL