/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 vote211 views1 answer
10000000000000000000 am to meters
SQL
0 vote233 views2 answers
What is the default password for sql server sa
SQL
0 vote192 views1 answer
Mysql select statement after index
SQL
0 vote218 views2 answers
Dumping sql table
SQL
0 vote188 views1 answer
Java spring boot connect to sql server
SQL
0 vote215 views1 answer
Hibernate show sql xml property
SQL
0 vote199 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
3 votes191 views1 answer
Sql multiple column index
SQL
25 votes200 views3 answers
How to use a database to see tables mysql
SQL
4 votes207 views1 answer
Wilayah indonesia sql
SQL