/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 vote124 views1 answer
Mysql error 1452
SQL
1 vote138 views1 answer
SQLite order random
SQL
6 votes171 views1 answer
How to get the size of the database in postgresql
SQL
1 vote177 views1 answer
Mysql print variable
SQL
1 vote139 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote155 views2 answers
Collation in sql
SQL
11 votes135 views3 answers
Sqlite3 create table from another table
SQL
0 vote155 views1 answer
Convert rows into columns in oracle
SQL
2 votes149 views1 answer
Create delete procedure mysql
SQL
0 vote139 views2 answers
Sql auto update dupdated_at
SQL