/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 vote67 views1 answer
Como leer datos de mysql esp32
SQL
1 vote110 views1 answer
Sql select table header
SQL
2 votes101 views1 answer
Check isolation level in mysql
SQL
1 vote104 views1 answer
Sometimes i cant edit sql developer
SQL
17 votes115 views3 answers
How to change a collumn name in sql
SQL
1 vote101 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote100 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote109 views1 answer
How to update sql server version
SQL
2 votes94 views2 answers
Compare date mysql
SQL
0 vote118 views1 answer
Shows all databases created by user in ms sql
SQL