/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 vote234 views1 answer
Download sql file of countries names
SQL
0 vote170 views1 answer
Go install mysql
SQL
1 vote194 views1 answer
Psql import backup file for windows
SQL
22 votes193 views3 answers
Year format in date mysql
SQL
0 vote187 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote185 views1 answer
How to open mysql in docker
SQL
0 vote188 views1 answer
Oracle sql log to console
SQL
0 vote178 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
1 vote201 views1 answer
Set id count mysql
SQL
0 vote152 views1 answer
Separator mysql
SQL