/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

5 votes117 views1 answer
Get table columns from sql
SQL
2 votes128 views1 answer
Install postgresql centos 5
SQL
0 vote103 views1 answer
Timestamp(0) postgresql
SQL
0 vote113 views1 answer
Create table like sql
SQL
20 votes121 views3 answers
How to open postgresql in mac
SQL
3 votes116 views1 answer
Select database in sql
SQL
0 vote99 views1 answer
Running query in redshift
SQL
1 vote115 views1 answer
Does insert into overwrite sql
SQL
1 vote94 views1 answer
Tsql random number
SQL
3 votes112 views1 answer
Oracle list invalid password ORA-01017
SQL