/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 vote337 views1 answer
Sql list all procedures
SQL
0 vote290 views1 answer
Check if due date is less than todays date sql
SQL
0 vote374 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote344 views1 answer
Oracle query archivemode
SQL
-1 vote331 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote354 views1 answer
Plpgsql raise notice
SQL
0 vote348 views1 answer
How to use group_concat in sql server
SQL
1 vote348 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote371 views1 answer
Change role postgres
SQL
0 vote345 views1 answer
Sql developer sql worksheet not showing
SQL