/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 vote175 views1 answer
Insert column after column mysql
SQL
0 vote182 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
9 votes159 views4 answers
Add primary key to existing table sql
SQL
1 vote167 views1 answer
Size of all tables in a schema oracle
SQL
1 vote153 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote167 views2 answers
Sql if empty then
SQL
1 vote189 views1 answer
Mysql alter decimal precision
SQL
22 votes229 views1 answer
Mysql workbench
SQL
0 vote197 views2 answers
Starts and end with vowel sql
SQL
1 vote196 views1 answer
Mysql check if string contains comma separated
SQL