/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 vote162 views1 answer
Sql server python connection
SQL
0 vote188 views1 answer
Generate random & unique mysql string
SQL
0 vote148 views1 answer
How to check xampp mysql password
SQL
0 vote191 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
5 votes118 views1 answer
Alter table default value mysql
SQL
1 vote154 views1 answer
Select not matching data from two tables
SQL
2 votes138 views3 answers
Postgres remove foreign key constraint
SQL
0 vote151 views3 answers
Drop multiple columns in sql
SQL
0 vote136 views1 answer
How to change null display in psql
SQL
0 vote153 views1 answer
Get date from timestamp in mysql
SQL