/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

5 votes192 views2 answers
Oracle timestamp to date
SQL
0 vote196 views2 answers
Mysql dump database tables only
SQL
2 votes186 views2 answers
Function in sql
SQL
3 votes212 views1 answer
Force using index oracle
SQL
1 vote189 views1 answer
ORA-01950
SQL
1 vote221 views1 answer
How do you use sql in you company
SQL
0 vote195 views1 answer
Get the next column of a table in mysql
SQL
1 vote219 views1 answer
T-SQL Alter the column data type
SQL
0 vote200 views2 answers
Sql regex vowel
SQL
5 votes172 views2 answers
Oracle list columns schema
SQL