/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 vote353 views1 answer
Change role postgres
SQL
0 vote323 views1 answer
Select from another database
SQL
7 votes345 views1 answer
Mysql iif
SQL
0 vote317 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
4 votes361 views2 answers
Oracle drop job
SQL
1 vote313 views1 answer
Mysql server does not start mac
SQL
1 vote332 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
2 votes324 views1 answer
No data found oracle
SQL
0 vote322 views1 answer
T-sql check if data exists
SQL
0 vote325 views3 answers
Sql select statements
SQL