/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
Mysql login console
SQL
0 vote210 views1 answer
Data types mysql vs postgresql
SQL
1 vote197 views1 answer
Sql row having max
SQL
1 vote182 views1 answer
Primary key with prefix sql
SQL
2 votes262 views2 answers
Postgres timestamp to datetime
SQL
8 votes232 views1 answer
Mac restore mysql database command line
SQL
0 vote235 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote203 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote204 views1 answer
Postgres get month name from date
SQL
0 vote196 views1 answer
Exectuer myssql .sql
SQL