/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

1 vote372 views1 answer
Pgsql sum switch case
SQL
11 votes374 views4 answers
MYSQL LOGIN
SQL
0 vote338 views1 answer
T sql return on letters only
SQL
5 votes376 views6 answers
In operator sql
SQL
0 vote323 views1 answer
Declaring variables in pl sql
SQL
2 votes380 views1 answer
Oracle trace file
SQL
0 vote334 views1 answer
Fix sqlite3 ruby on rails
SQL
4 votes347 views1 answer
Create table if not exist in sqlite
SQL
0 vote349 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote398 views1 answer
Sql ssrs
SQL