/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

53 votes272 views6 answers
How to install mysql ubuntu
SQL
1 vote119 views1 answer
Postgres see sequence current state
SQL
5 votes108 views2 answers
Oracle find all tables with column name
SQL
0 vote100 views2 answers
Script all indexes in a database
SQL
17 votes228 views4 answers
Show all tables in oracle
SQL
0 vote103 views2 answers
How to update date in oracle
SQL
0 vote140 views1 answer
Mysql grant access to one database
SQL
0 vote63 views1 answer
Store query result in variable sql
SQL
0 vote98 views1 answer
How to write if case in select query in select statement
SQL
0 vote98 views1 answer
Oracle for loop on list
SQL