/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 vote204 views1 answer
Mysql current running queries
SQL
0 vote197 views1 answer
Where date in datetime mysql
SQL
1 vote189 views1 answer
Create table variable in sql stored procedure
SQL
49 votes197 views6 answers
Alter table add column
SQL
-2 votes187 views1 answer
Modify column name in tsql
SQL
1 vote215 views2 answers
Oracle create synonym
SQL
0 vote200 views1 answer
What is top n result in sql
SQL
0 vote204 views1 answer
Prodection ready postgres database step by step
SQL
1 vote192 views1 answer
Stop mysql server mac
SQL
0 vote224 views1 answer
Dual in db2
SQL