/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

1 vote347 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
2 votes294 views3 answers
Mysql list tables by size
SQL
10 votes299 views2 answers
Forgot my mysql password mac
SQL
0 vote317 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote313 views1 answer
Select row with latest date mysql
SQL
23 votes307 views4 answers
Sql server substring
SQL
1 vote313 views1 answer
Sql not equal multiple columns
SQL
0 vote382 views1 answer
Redshift running queries
SQL
1 vote290 views2 answers
Oracle replace
SQL
0 vote335 views1 answer
See the structure of a table mysql
SQL