/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

10 votes337 views3 answers
Join multiple tables sql
SQL
16 votes336 views1 answer
Mssql int max value
SQL
0 vote333 views1 answer
Call function sql oracle with output put line
SQL
0 vote338 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
32 votes349 views6 answers
Insert select
SQL
0 vote337 views1 answer
Enable sql server full text indexing
SQL
45 votes397 views5 answers
Grant all privileges mysql
SQL
-2 votes348 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote338 views1 answer
Change filed order in mysql
SQL
9 votes308 views3 answers
Where in sql
SQL