/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

2 votes140 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote128 views1 answer
Reset keys in sql
SQL
0 vote113 views1 answer
Big table in mysql
SQL
11 votes107 views2 answers
Insert date sql
SQL
0 vote175 views2 answers
Wordpress change url in database
SQL
0 vote112 views2 answers
Get all index postgres
SQL
28 votes79 views6 answers
Distinct sql
SQL
11 votes145 views2 answers
Set default column value sql
SQL
0 vote157 views1 answer
SQL-Arten
SQL
3 votes138 views2 answers
Oracle drop sequence
SQL