/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 vote146 views1 answer
Luu ckeditor vao mysql
SQL
2 votes171 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes148 views1 answer
Oracle find unusable indexes
SQL
3 votes130 views1 answer
Oracle failed login attempts
SQL
4 votes158 views4 answers
Check constraint in ms sql
SQL
1 vote158 views1 answer
Does insert into overwrite sql
SQL
6 votes140 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote156 views1 answer
Update view sql
SQL
0 vote167 views1 answer
How to change mysql port in xampp
SQL
0 vote162 views1 answer
Creating a simple notify in postgresql
SQL